{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('surveydata/survey_results_public.csv', index_col = \"Respondent\")\n",
    "s_df = pd.read_csv('surveydata/survey_results_schema.csv', index_col = \"Column\")\n",
    "\n",
    "pd.set_option('display.max_columns', 61)\n",
    "pd.set_option('display.max_rows', 61)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DevType</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Gender</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>NEWCollabToolsDesireNextYear</th>\n",
       "      <th>NEWCollabToolsWorkedWith</th>\n",
       "      <th>NEWDevOps</th>\n",
       "      <th>NEWDevOpsImpt</th>\n",
       "      <th>NEWEdImpt</th>\n",
       "      <th>NEWJobHunt</th>\n",
       "      <th>NEWJobHuntResearch</th>\n",
       "      <th>NEWLearn</th>\n",
       "      <th>NEWOffTopic</th>\n",
       "      <th>NEWOnboardGood</th>\n",
       "      <th>NEWOtherComms</th>\n",
       "      <th>NEWOvertime</th>\n",
       "      <th>NEWPurchaseResearch</th>\n",
       "      <th>NEWPurpleLink</th>\n",
       "      <th>NEWSOSites</th>\n",
       "      <th>NEWStuck</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Elasticsearch;Microsoft SQL Server;Oracle</td>\n",
       "      <td>Developer, desktop or enterprise applications;...</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>Independent contractor, freelancer, or self-em...</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>C#;HTML/CSS;JavaScript</td>\n",
       "      <td>C#;HTML/CSS;JavaScript</td>\n",
       "      <td>.NET Core;Xamarin</td>\n",
       "      <td>.NET;.NET Core</td>\n",
       "      <td>Microsoft Teams;Microsoft Azure;Trello</td>\n",
       "      <td>Confluence;Jira;Slack;Microsoft Azure;Trello</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Often: 1-2 days per week or more</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow;Go for a walk or other ph...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>2 to 9 employees</td>\n",
       "      <td>Android;iOS;Kubernetes;Microsoft Azure;Windows</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>No</td>\n",
       "      <td>No, not at all</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>ASP.NET;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>36</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Developer, full-stack;Developer, mobile</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very dissatisfied</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>Python;Swift</td>\n",
       "      <td>JavaScript;Swift</td>\n",
       "      <td>React Native;TensorFlow;Unity 3D</td>\n",
       "      <td>React Native</td>\n",
       "      <td>Github;Slack</td>\n",
       "      <td>Confluence;Jira;Github;Gitlab;Slack</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Visit Stack Overflow;Go for a walk or other ph...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>1,000 to 4,999 employees</td>\n",
       "      <td>iOS;Kubernetes;Linux;MacOS</td>\n",
       "      <td>iOS</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I code primarily as a hobby</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Objective-C;Python;Swift</td>\n",
       "      <td>Objective-C;Python;Swift</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a decade</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Albanian lek</td>\n",
       "      <td>ALL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule;Office enviro...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not at all important/not necessary</td>\n",
       "      <td>Curious about other opportunities;Wanting to w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>I used to be a developer by profession, but no...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>31.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MySQL;PostgreSQL</td>\n",
       "      <td>MySQL;PostgreSQL;Redis;SQLite</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java;Ruby;Scala</td>\n",
       "      <td>HTML/CSS;Ruby;SQL</td>\n",
       "      <td>Ansible;Chef</td>\n",
       "      <td>Ansible</td>\n",
       "      <td>Github;Google Suite (Docs, Meet, etc)</td>\n",
       "      <td>Confluence;Jira;Github;Slack;Google Suite (Doc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Docker;Google Cloud Platform;Heroku;Linux;Windows</td>\n",
       "      <td>AWS;Docker;Linux;MacOS;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Ruby on Rails</td>\n",
       "      <td>Ruby on Rails</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64858</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Senior executive/VP</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a decade</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Call a coworker or friend</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64867</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...</td>\n",
       "      <td>Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64898</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Primary/elementary school</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64925</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DynamoDB;Elasticsearch;MongoDB;MySQL;PostgreSQL</td>\n",
       "      <td>Oracle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HTML/CSS;Java;JavaScript</td>\n",
       "      <td>HTML/CSS</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github;Gitlab</td>\n",
       "      <td>Confluence;Jira;Slack;Microsoft Teams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular;Angular.js;React.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65112</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MariaDB;Microsoft SQL Server</td>\n",
       "      <td>MariaDB;Microsoft SQL Server;MySQL;Oracle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other doctoral degree (Ph.D., Ed.D., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#;HTML/CSS;Java;JavaScript;SQL</td>\n",
       "      <td>C#;HTML/CSS;Java;JavaScript;SQL</td>\n",
       "      <td>.NET Core;Xamarin</td>\n",
       "      <td>.NET;.NET Core</td>\n",
       "      <td>Github;Microsoft Teams</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Critically important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Indifferent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Meditate;Visit Stack Overflow;Go for a walk or...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arduino;Linux;Raspberry Pi;Windows</td>\n",
       "      <td>Android;Arduino;Linux;Raspberry Pi;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;jQuery</td>\n",
       "      <td>Angular;Angular.js;ASP.NET Core;jQuery</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "1                              I am a developer by profession      Yes   NaN   \n",
       "2                              I am a developer by profession       No   NaN   \n",
       "3                                 I code primarily as a hobby      Yes   NaN   \n",
       "4                              I am a developer by profession      Yes  25.0   \n",
       "5           I used to be a developer by profession, but no...      Yes  31.0   \n",
       "...                                                       ...      ...   ...   \n",
       "64858                                                     NaN      Yes   NaN   \n",
       "64867                                                     NaN      Yes   NaN   \n",
       "64898                                                     NaN      Yes   NaN   \n",
       "64925                                                     NaN      Yes   NaN   \n",
       "65112                                                     NaN      Yes   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  ConvertedComp             Country  \\\n",
       "Respondent                                                                     \n",
       "1                  13  Monthly        NaN            NaN             Germany   \n",
       "2                  19      NaN        NaN            NaN      United Kingdom   \n",
       "3                  15      NaN        NaN            NaN  Russian Federation   \n",
       "4                  18      NaN        NaN            NaN             Albania   \n",
       "5                  16      NaN        NaN            NaN       United States   \n",
       "...               ...      ...        ...            ...                 ...   \n",
       "64858              16      NaN        NaN            NaN       United States   \n",
       "64867             NaN      NaN        NaN            NaN             Morocco   \n",
       "64898             NaN      NaN        NaN            NaN            Viet Nam   \n",
       "64925             NaN      NaN        NaN            NaN              Poland   \n",
       "65112             NaN      NaN        NaN            NaN               Spain   \n",
       "\n",
       "              CurrencyDesc CurrencySymbol  \\\n",
       "Respondent                                  \n",
       "1            European Euro            EUR   \n",
       "2           Pound sterling            GBP   \n",
       "3                      NaN            NaN   \n",
       "4             Albanian lek            ALL   \n",
       "5                      NaN            NaN   \n",
       "...                    ...            ...   \n",
       "64858                  NaN            NaN   \n",
       "64867                  NaN            NaN   \n",
       "64898                  NaN            NaN   \n",
       "64925                  NaN            NaN   \n",
       "65112                  NaN            NaN   \n",
       "\n",
       "                                       DatabaseDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1                                        Microsoft SQL Server   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                            MySQL;PostgreSQL   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...   \n",
       "64898                                                     NaN   \n",
       "64925         DynamoDB;Elasticsearch;MongoDB;MySQL;PostgreSQL   \n",
       "65112                            MariaDB;Microsoft SQL Server   \n",
       "\n",
       "                                           DatabaseWorkedWith  \\\n",
       "Respondent                                                      \n",
       "1                   Elasticsearch;Microsoft SQL Server;Oracle   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                               MySQL;PostgreSQL;Redis;SQLite   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...   \n",
       "64898                                                     NaN   \n",
       "64925                                                  Oracle   \n",
       "65112               MariaDB;Microsoft SQL Server;MySQL;Oracle   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "1           Developer, desktop or enterprise applications;...   \n",
       "2                     Developer, full-stack;Developer, mobile   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                     Senior executive/VP   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                                    EdLevel  \\\n",
       "Respondent                                                    \n",
       "1           Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "2              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "3                                                       NaN   \n",
       "4           Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "5              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "...                                                     ...   \n",
       "64858       Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "64867                                                   NaN   \n",
       "64898                             Primary/elementary school   \n",
       "64925                                                   NaN   \n",
       "65112            Other doctoral degree (Ph.D., Ed.D., etc.)   \n",
       "\n",
       "                                                   Employment  \\\n",
       "Respondent                                                      \n",
       "1           Independent contractor, freelancer, or self-em...   \n",
       "2                                          Employed full-time   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                          Employed full-time   \n",
       "...                                                       ...   \n",
       "64858                                      Employed full-time   \n",
       "64867                                      Employed full-time   \n",
       "64898                                                     NaN   \n",
       "64925                                      Employed full-time   \n",
       "65112                                      Employed full-time   \n",
       "\n",
       "                               Ethnicity Gender  \\\n",
       "Respondent                                        \n",
       "1           White or of European descent    Man   \n",
       "2                                    NaN    NaN   \n",
       "3                                    NaN    NaN   \n",
       "4           White or of European descent    Man   \n",
       "5           White or of European descent    Man   \n",
       "...                                  ...    ...   \n",
       "64858                                NaN    NaN   \n",
       "64867                                NaN    NaN   \n",
       "64898                                NaN    NaN   \n",
       "64925                                NaN    NaN   \n",
       "65112                                NaN    NaN   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "1           Languages, frameworks, and other technologies ...   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4           Flex time or a flexible schedule;Office enviro...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                           JobSat  \\\n",
       "Respondent                          \n",
       "1              Slightly satisfied   \n",
       "2               Very dissatisfied   \n",
       "3                             NaN   \n",
       "4           Slightly dissatisfied   \n",
       "5                             NaN   \n",
       "...                           ...   \n",
       "64858                         NaN   \n",
       "64867                         NaN   \n",
       "64898                         NaN   \n",
       "64925                         NaN   \n",
       "65112                         NaN   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "1                I am not interested in new job opportunities   \n",
       "2                I am not interested in new job opportunities   \n",
       "3                                                         NaN   \n",
       "4           I’m not actively looking, but I am open to new...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1                                      C#;HTML/CSS;JavaScript   \n",
       "2                                                Python;Swift   \n",
       "3                                    Objective-C;Python;Swift   \n",
       "4                                                         NaN   \n",
       "5                                             Java;Ruby;Scala   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "64898                                                     NaN   \n",
       "64925                                HTML/CSS;Java;JavaScript   \n",
       "65112                         C#;HTML/CSS;Java;JavaScript;SQL   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "1                                      C#;HTML/CSS;JavaScript   \n",
       "2                                            JavaScript;Swift   \n",
       "3                                    Objective-C;Python;Swift   \n",
       "4                                                         NaN   \n",
       "5                                           HTML/CSS;Ruby;SQL   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "64898                                                     NaN   \n",
       "64925                                                HTML/CSS   \n",
       "65112                         C#;HTML/CSS;Java;JavaScript;SQL   \n",
       "\n",
       "                      MiscTechDesireNextYear MiscTechWorkedWith  \\\n",
       "Respondent                                                        \n",
       "1                          .NET Core;Xamarin     .NET;.NET Core   \n",
       "2           React Native;TensorFlow;Unity 3D       React Native   \n",
       "3                                        NaN                NaN   \n",
       "4                                        NaN                NaN   \n",
       "5                               Ansible;Chef            Ansible   \n",
       "...                                      ...                ...   \n",
       "64858                                    NaN                NaN   \n",
       "64867                                    NaN                NaN   \n",
       "64898                                    NaN                NaN   \n",
       "64925                                Node.js                NaN   \n",
       "65112                      .NET Core;Xamarin     .NET;.NET Core   \n",
       "\n",
       "                      NEWCollabToolsDesireNextYear  \\\n",
       "Respondent                                           \n",
       "1           Microsoft Teams;Microsoft Azure;Trello   \n",
       "2                                     Github;Slack   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "5            Github;Google Suite (Docs, Meet, etc)   \n",
       "...                                            ...   \n",
       "64858                                          NaN   \n",
       "64867                                          NaN   \n",
       "64898                                          NaN   \n",
       "64925                                Github;Gitlab   \n",
       "65112                       Github;Microsoft Teams   \n",
       "\n",
       "                                     NEWCollabToolsWorkedWith NEWDevOps  \\\n",
       "Respondent                                                                \n",
       "1                Confluence;Jira;Slack;Microsoft Azure;Trello        No   \n",
       "2                         Confluence;Jira;Github;Gitlab;Slack       NaN   \n",
       "3                                                         NaN       NaN   \n",
       "4                                                         NaN        No   \n",
       "5           Confluence;Jira;Github;Slack;Google Suite (Doc...       NaN   \n",
       "...                                                       ...       ...   \n",
       "64858                                                     NaN       NaN   \n",
       "64867                                                     NaN       NaN   \n",
       "64898                                                     NaN       NaN   \n",
       "64925                   Confluence;Jira;Slack;Microsoft Teams       NaN   \n",
       "65112                                                  Github       NaN   \n",
       "\n",
       "                 NEWDevOpsImpt                           NEWEdImpt  \\\n",
       "Respondent                                                           \n",
       "1           Somewhat important                    Fairly important   \n",
       "2                          NaN                    Fairly important   \n",
       "3                          NaN                                 NaN   \n",
       "4                          NaN  Not at all important/not necessary   \n",
       "5                          NaN                      Very important   \n",
       "...                        ...                                 ...   \n",
       "64858                      NaN                      Very important   \n",
       "64867                      NaN                                 NaN   \n",
       "64898                      NaN                                 NaN   \n",
       "64925                      NaN                                 NaN   \n",
       "65112                      NaN                Critically important   \n",
       "\n",
       "                                                   NEWJobHunt  \\\n",
       "Respondent                                                      \n",
       "1                                                         NaN   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4           Curious about other opportunities;Wanting to w...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "           NEWJobHuntResearch       NEWLearn NEWOffTopic NEWOnboardGood  \\\n",
       "Respondent                                                                \n",
       "1                         NaN    Once a year    Not sure            NaN   \n",
       "2                         NaN    Once a year    Not sure            NaN   \n",
       "3                         NaN  Once a decade         NaN            NaN   \n",
       "4                         NaN    Once a year    Not sure            Yes   \n",
       "5                         NaN    Once a year          No            NaN   \n",
       "...                       ...            ...         ...            ...   \n",
       "64858                     NaN  Once a decade         NaN            NaN   \n",
       "64867                     NaN            NaN         NaN            NaN   \n",
       "64898                     NaN            NaN         NaN            NaN   \n",
       "64925                     NaN    Once a year         NaN            NaN   \n",
       "65112                     NaN    Once a year         NaN            NaN   \n",
       "\n",
       "           NEWOtherComms                                        NEWOvertime  \\\n",
       "Respondent                                                                    \n",
       "1                     No                   Often: 1-2 days per week or more   \n",
       "2                     No                                                NaN   \n",
       "3                     No                                                NaN   \n",
       "4                    Yes  Occasionally: 1-2 days per quarter but less th...   \n",
       "5                    Yes                                                NaN   \n",
       "...                  ...                                                ...   \n",
       "64858                NaN                                                NaN   \n",
       "64867                NaN                                                NaN   \n",
       "64898                NaN                                                NaN   \n",
       "64925                NaN                                                NaN   \n",
       "65112                NaN                                                NaN   \n",
       "\n",
       "                                          NEWPurchaseResearch  \\\n",
       "Respondent                                                      \n",
       "1           Start a free trial;Ask developers I know/work ...   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5           Start a free trial;Ask developers I know/work ...   \n",
       "...                                                       ...   \n",
       "64858                                      Start a free trial   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                      Start a free trial   \n",
       "65112       Start a free trial;Ask developers I know/work ...   \n",
       "\n",
       "                NEWPurpleLink  \\\n",
       "Respondent                      \n",
       "1                      Amused   \n",
       "2                      Amused   \n",
       "3                         NaN   \n",
       "4                         NaN   \n",
       "5           Hello, old friend   \n",
       "...                       ...   \n",
       "64858                  Amused   \n",
       "64867                     NaN   \n",
       "64898                     NaN   \n",
       "64925       Hello, old friend   \n",
       "65112             Indifferent   \n",
       "\n",
       "                                                   NEWSOSites  \\\n",
       "Respondent                                                      \n",
       "1            Stack Overflow (public Q&A for anyone who codes)   \n",
       "2           Stack Overflow (public Q&A for anyone who code...   \n",
       "3            Stack Overflow (public Q&A for anyone who codes)   \n",
       "4           Stack Overflow (public Q&A for anyone who code...   \n",
       "5           Stack Overflow (public Q&A for anyone who code...   \n",
       "...                                                       ...   \n",
       "64858        Stack Overflow (public Q&A for anyone who codes)   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925        Stack Overflow (public Q&A for anyone who codes)   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                                     NEWStuck        OpSys  \\\n",
       "Respondent                                                                   \n",
       "1           Visit Stack Overflow;Go for a walk or other ph...      Windows   \n",
       "2           Visit Stack Overflow;Go for a walk or other ph...        MacOS   \n",
       "3                                                         NaN  Linux-based   \n",
       "4                                                         NaN  Linux-based   \n",
       "5           Call a coworker or friend;Visit Stack Overflow...      Windows   \n",
       "...                                                       ...          ...   \n",
       "64858                               Call a coworker or friend      Windows   \n",
       "64867                                                     NaN          NaN   \n",
       "64898                                                     NaN          NaN   \n",
       "64925          Call a coworker or friend;Visit Stack Overflow      Windows   \n",
       "65112       Meditate;Visit Stack Overflow;Go for a walk or...      Windows   \n",
       "\n",
       "                             OrgSize  \\\n",
       "Respondent                             \n",
       "1                   2 to 9 employees   \n",
       "2           1,000 to 4,999 employees   \n",
       "3                                NaN   \n",
       "4                 20 to 99 employees   \n",
       "5                                NaN   \n",
       "...                              ...   \n",
       "64858                            NaN   \n",
       "64867                            NaN   \n",
       "64898                            NaN   \n",
       "64925                            NaN   \n",
       "65112                            NaN   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1              Android;iOS;Kubernetes;Microsoft Azure;Windows   \n",
       "2                                  iOS;Kubernetes;Linux;MacOS   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5           Docker;Google Cloud Platform;Heroku;Linux;Windows   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                      Arduino;Linux;Raspberry Pi;Windows   \n",
       "\n",
       "                                    PlatformWorkedWith  \\\n",
       "Respondent                                               \n",
       "1                                              Windows   \n",
       "2                                                  iOS   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "5                       AWS;Docker;Linux;MacOS;Windows   \n",
       "...                                                ...   \n",
       "64858                                              NaN   \n",
       "64867                                              NaN   \n",
       "64898                                              NaN   \n",
       "64925                                    Linux;Windows   \n",
       "65112       Android;Arduino;Linux;Raspberry Pi;Windows   \n",
       "\n",
       "                                PurchaseWhat                Sexuality  \\\n",
       "Respondent                                                              \n",
       "1                                        NaN  Straight / Heterosexual   \n",
       "2              I have little or no influence                      NaN   \n",
       "3                                        NaN                      NaN   \n",
       "4           I have a great deal of influence  Straight / Heterosexual   \n",
       "5                                        NaN  Straight / Heterosexual   \n",
       "...                                      ...                      ...   \n",
       "64858                                    NaN                      NaN   \n",
       "64867                                    NaN                      NaN   \n",
       "64898                                    NaN                      NaN   \n",
       "64925                                    NaN                      NaN   \n",
       "65112                                    NaN                      NaN   \n",
       "\n",
       "           SOAccount           SOComm                           SOPartFreq  \\\n",
       "Respondent                                                                   \n",
       "1                 No   No, not at all                                  NaN   \n",
       "2                Yes  Yes, definitely  Less than once per month or monthly   \n",
       "3                Yes    Yes, somewhat      A few times per month or weekly   \n",
       "4                Yes  Yes, definitely      A few times per month or weekly   \n",
       "5                Yes    Yes, somewhat  Less than once per month or monthly   \n",
       "...              ...              ...                                  ...   \n",
       "64858            NaN              NaN                                  NaN   \n",
       "64867            NaN              NaN                                  NaN   \n",
       "64898            NaN              NaN                                  NaN   \n",
       "64925            NaN              NaN                                  NaN   \n",
       "65112            NaN              NaN                                  NaN   \n",
       "\n",
       "                                SOVisitFreq                  SurveyEase  \\\n",
       "Respondent                                                                \n",
       "1                    Multiple times per day  Neither easy nor difficult   \n",
       "2                    Multiple times per day                         NaN   \n",
       "3                     Daily or almost daily  Neither easy nor difficult   \n",
       "4                    Multiple times per day                         NaN   \n",
       "5           A few times per month or weekly                        Easy   \n",
       "...                                     ...                         ...   \n",
       "64858                                   NaN                         NaN   \n",
       "64867                                   NaN                         NaN   \n",
       "64898                                   NaN                         NaN   \n",
       "64925                                   NaN                         NaN   \n",
       "65112                                   NaN                         NaN   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "1           Appropriate in length    No   \n",
       "2                             NaN   NaN   \n",
       "3           Appropriate in length   NaN   \n",
       "4                             NaN    No   \n",
       "5                       Too short    No   \n",
       "...                           ...   ...   \n",
       "64858                         NaN   NaN   \n",
       "64867                         NaN   NaN   \n",
       "64898                         NaN   NaN   \n",
       "64925                         NaN   NaN   \n",
       "65112                         NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "1           Computer science, computer engineering, or sof...   \n",
       "2           Computer science, computer engineering, or sof...   \n",
       "3                                                         NaN   \n",
       "4           Computer science, computer engineering, or sof...   \n",
       "5           Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "64858       Computer science, computer engineering, or sof...   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112       Computer science, computer engineering, or sof...   \n",
       "\n",
       "                 WebframeDesireNextYear  \\\n",
       "Respondent                                \n",
       "1                          ASP.NET Core   \n",
       "2                                   NaN   \n",
       "3                                   NaN   \n",
       "4                                   NaN   \n",
       "5                  Django;Ruby on Rails   \n",
       "...                                 ...   \n",
       "64858                               NaN   \n",
       "64867                               NaN   \n",
       "64898                               NaN   \n",
       "64925       Angular;Angular.js;React.js   \n",
       "65112               ASP.NET Core;jQuery   \n",
       "\n",
       "                                WebframeWorkedWith  \\\n",
       "Respondent                                           \n",
       "1                             ASP.NET;ASP.NET Core   \n",
       "2                                              NaN   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "5                                    Ruby on Rails   \n",
       "...                                            ...   \n",
       "64858                                          NaN   \n",
       "64867                                          NaN   \n",
       "64898                                          NaN   \n",
       "64925                                          NaN   \n",
       "65112       Angular;Angular.js;ASP.NET Core;jQuery   \n",
       "\n",
       "                                       WelcomeChange  WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                    \n",
       "1            Just as welcome now as I felt last year         50.0        36   \n",
       "2           Somewhat more welcome now than last year          NaN         7   \n",
       "3           Somewhat more welcome now than last year          NaN         4   \n",
       "4           Somewhat less welcome now than last year         40.0         7   \n",
       "5            Just as welcome now as I felt last year          NaN        15   \n",
       "...                                              ...          ...       ...   \n",
       "64858                                            NaN          NaN        10   \n",
       "64867                                            NaN          NaN       NaN   \n",
       "64898                                            NaN          NaN       NaN   \n",
       "64925                                            NaN          NaN       NaN   \n",
       "65112                                            NaN          NaN       NaN   \n",
       "\n",
       "                YearsCodePro  \n",
       "Respondent                    \n",
       "1                         27  \n",
       "2                          4  \n",
       "3                        NaN  \n",
       "4                          4  \n",
       "5                          8  \n",
       "...                      ...  \n",
       "64858       Less than 1 year  \n",
       "64867                    NaN  \n",
       "64898                    NaN  \n",
       "64925                    NaN  \n",
       "65112                    NaN  \n",
       "\n",
       "[64461 rows x 60 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "54049.0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"ConvertedComp\"].median() # calculating median of the salaries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Age                 29.0\n",
       "CompTotal        63000.0\n",
       "ConvertedComp    54049.0\n",
       "WorkWeekHrs         40.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.median() # calculating the median of all columns with values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>45446.000000</td>\n",
       "      <td>3.482600e+04</td>\n",
       "      <td>3.475600e+04</td>\n",
       "      <td>41151.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>30.834111</td>\n",
       "      <td>3.190464e+242</td>\n",
       "      <td>1.037561e+05</td>\n",
       "      <td>40.782174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>9.585392</td>\n",
       "      <td>inf</td>\n",
       "      <td>2.268853e+05</td>\n",
       "      <td>17.816383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>2.000000e+04</td>\n",
       "      <td>2.464800e+04</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>29.000000</td>\n",
       "      <td>6.300000e+04</td>\n",
       "      <td>5.404900e+04</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>1.250000e+05</td>\n",
       "      <td>9.500000e+04</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>279.000000</td>\n",
       "      <td>1.111111e+247</td>\n",
       "      <td>2.000000e+06</td>\n",
       "      <td>475.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Age      CompTotal  ConvertedComp   WorkWeekHrs\n",
       "count  45446.000000   3.482600e+04   3.475600e+04  41151.000000\n",
       "mean      30.834111  3.190464e+242   1.037561e+05     40.782174\n",
       "std        9.585392            inf   2.268853e+05     17.816383\n",
       "min        1.000000   0.000000e+00   0.000000e+00      1.000000\n",
       "25%       24.000000   2.000000e+04   2.464800e+04     40.000000\n",
       "50%       29.000000   6.300000e+04   5.404900e+04     40.000000\n",
       "75%       35.000000   1.250000e+05   9.500000e+04     44.000000\n",
       "max      279.000000  1.111111e+247   2.000000e+06    475.000000"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe() # gives count, mean, standard daviation and etc for all the data containing numarical values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34756"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"ConvertedComp\"].count() # count the number but doesnt count NaN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1        Yes\n",
       "2         No\n",
       "3        Yes\n",
       "4        Yes\n",
       "5        Yes\n",
       "        ... \n",
       "64858    Yes\n",
       "64867    Yes\n",
       "64898    Yes\n",
       "64925    Yes\n",
       "65112    Yes\n",
       "Name: Hobbyist, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Hobbyist\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Yes    50388\n",
       "No     14028\n",
       "Name: Hobbyist, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Hobbyist\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1            Windows\n",
       "2              MacOS\n",
       "3        Linux-based\n",
       "4        Linux-based\n",
       "5            Windows\n",
       "            ...     \n",
       "64858        Windows\n",
       "64867            NaN\n",
       "64898            NaN\n",
       "64925        Windows\n",
       "65112        Windows\n",
       "Name: OpSys, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"OpSys\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Windows        27170\n",
       "Linux-based    14932\n",
       "MacOS          14075\n",
       "BSD               51\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"OpSys\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Windows        0.483211\n",
       "Linux-based    0.265562\n",
       "MacOS          0.250320\n",
       "BSD            0.000907\n",
       "Name: OpSys, dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"OpSys\"].value_counts(normalize = True) # count in percentage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United States     12469\n",
       "India              8403\n",
       "United Kingdom     3896\n",
       "Germany            3890\n",
       "Canada             2191\n",
       "                  ...  \n",
       "Kiribati              1\n",
       "Chad                  1\n",
       "Grenada               1\n",
       "Saint Lucia           1\n",
       "Lesotho               1\n",
       "Name: Country, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Country\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "countrygrp = df.groupby([\"Country\"]) # creating a country grp var"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x0000022782CBA3D0>"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DevType</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Gender</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>NEWCollabToolsDesireNextYear</th>\n",
       "      <th>NEWCollabToolsWorkedWith</th>\n",
       "      <th>NEWDevOps</th>\n",
       "      <th>NEWDevOpsImpt</th>\n",
       "      <th>NEWEdImpt</th>\n",
       "      <th>NEWJobHunt</th>\n",
       "      <th>NEWJobHuntResearch</th>\n",
       "      <th>NEWLearn</th>\n",
       "      <th>NEWOffTopic</th>\n",
       "      <th>NEWOnboardGood</th>\n",
       "      <th>NEWOtherComms</th>\n",
       "      <th>NEWOvertime</th>\n",
       "      <th>NEWPurchaseResearch</th>\n",
       "      <th>NEWPurpleLink</th>\n",
       "      <th>NEWSOSites</th>\n",
       "      <th>NEWStuck</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Couchbase;Elasticsearch;Firebase;MongoDB;MySQL...</td>\n",
       "      <td>Couchbase;MongoDB;PostgreSQL</td>\n",
       "      <td>Developer, back-end;Developer, desktop or ente...</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule;How widely us...</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>Dart;Go;HTML/CSS;Java;JavaScript;Python;Rust;T...</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...</td>\n",
       "      <td>.NET Core;Flutter;Node.js;Pandas;React Native;...</td>\n",
       "      <td>Cordova;Node.js</td>\n",
       "      <td>Confluence;Jira;Github;Trello;Google Suite (Do...</td>\n",
       "      <td>Confluence;Jira;Github;Gitlab;Trello;Google Su...</td>\n",
       "      <td>No</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Very important</td>\n",
       "      <td>Curious about other opportunities;Better compe...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Play games;Call a coworker or friend;Visit Sta...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>AWS;Docker;Google Cloud Platform;Kubernetes;Li...</td>\n",
       "      <td>Android;Arduino;AWS;Docker;iOS;Linux;MacOS</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Django;Express;React.js;Spring</td>\n",
       "      <td>Angular;Angular.js;Express;jQuery;Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>32.0</td>\n",
       "      <td>22</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>220000.0</td>\n",
       "      <td>17124.0</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Firebase;MongoDB;Redis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Developer, front-end;Developer, full-stack</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I am actively looking for a job</td>\n",
       "      <td>JavaScript;SQL;TypeScript</td>\n",
       "      <td>HTML/CSS;JavaScript</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jira;Github;Slack;Trello;Google Suite (Docs, M...</td>\n",
       "      <td>Jira;Github;Slack;Trello;Google Suite (Docs, M...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Curious about other opportunities;Better compe...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely: 1-2 days per year or less</td>\n",
       "      <td>Ask developers I know/work with;Visit develope...</td>\n",
       "      <td>Annoyed</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>100 to 499 employees</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Express;jQuery;React.js;Vue.js</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>634</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Academic researcher;Developer, desktop or ente...</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Independent contractor, freelancer, or self-em...</td>\n",
       "      <td>East Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule</td>\n",
       "      <td>Neither satisfied nor dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>C#;Java</td>\n",
       "      <td>C#;Java</td>\n",
       "      <td>.NET</td>\n",
       "      <td>.NET</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Not at all important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Better compensation;Trouble with my direct man...</td>\n",
       "      <td>Directly asking current or past employees at t...</td>\n",
       "      <td>Once every few years</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Annoyed</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Just me - I am a freelancer, sole proprietor, ...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Information systems, information technology, o...</td>\n",
       "      <td>ASP.NET</td>\n",
       "      <td>ASP.NET</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Firebase;MySQL;SQLite</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I am actively looking for a job</td>\n",
       "      <td>C</td>\n",
       "      <td>C;HTML/CSS;Java;JavaScript;PHP;Python;SQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just because</td>\n",
       "      <td>Personal network - friends or family</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow Jobs (for job seekers)</td>\n",
       "      <td>Watch help / tutorial videos</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Laravel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Data scientist or machine learning specialist</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Industry that I’d be working in;Remote work op...</td>\n",
       "      <td>Neither satisfied nor dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>Python;Scala</td>\n",
       "      <td>Python;R</td>\n",
       "      <td>Apache Spark;Hadoop;Keras;TensorFlow;Torch/PyT...</td>\n",
       "      <td>Keras;TensorFlow</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github</td>\n",
       "      <td>No</td>\n",
       "      <td>Not very important</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Having a bad day (or week or month) at work;Be...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Sometimes: 1-2 days per month but less than we...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow;Watch help / tutorial vid...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>10,000 or more employees</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22462</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>22.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MongoDB;MySQL</td>\n",
       "      <td>MongoDB;MySQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>Southeast Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#;JavaScript;Python;SQL</td>\n",
       "      <td>C#;HTML/CSS;Java;JavaScript;PHP;Python;SQL</td>\n",
       "      <td>.NET Core;Node.js;React Native</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Visit developer communities...</td>\n",
       "      <td>Indifferent</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Visit Stack Overflow;Watch help / tutorial videos</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android;Heroku;iOS;Windows</td>\n",
       "      <td>Heroku;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Express;React.js</td>\n",
       "      <td>Express;jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47832</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed part-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have never visited any of these sites</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A natural science (such as biology, chemistry,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55211</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cassandra</td>\n",
       "      <td>Cassandra</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Professional degree (JD, MD, etc.)</td>\n",
       "      <td>Student</td>\n",
       "      <td>Middle Eastern</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assembly</td>\n",
       "      <td>Assembly</td>\n",
       "      <td>.NET</td>\n",
       "      <td>.NET</td>\n",
       "      <td>Google Suite (Docs, Meet, etc)</td>\n",
       "      <td>Google Suite (Docs, Meet, etc)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Annoyed</td>\n",
       "      <td>I have never visited any of these sites</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Google Cloud Platform</td>\n",
       "      <td>Google Cloud Platform</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>Angular</td>\n",
       "      <td>Angular</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55815</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>Database administrator</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employed part-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C++;JavaScript</td>\n",
       "      <td>C++;JavaScript</td>\n",
       "      <td>.NET</td>\n",
       "      <td>.NET</td>\n",
       "      <td>Facebook Workplace</td>\n",
       "      <td>Facebook Workplace</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow Jobs (for job seekers)</td>\n",
       "      <td>Meditate;Play games;Call a coworker or friend;...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android;Linux</td>\n",
       "      <td>Android;Linux</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Express</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Less than 1 year</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61983</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Microsoft SQL Server;MySQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Data or business analyst</td>\n",
       "      <td>Secondary school (e.g. American high school, G...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>East Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HTML/CSS;Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.NET;Unreal Engine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Confluence;Slack</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once every few years</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow Jobs (for job seekers)</td>\n",
       "      <td>Visit Stack Overflow</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Google Cloud Platform</td>\n",
       "      <td>Android</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Django;Flask</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Less than 1 year</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>809 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist   Age Age1stCode CompFreq  \\\n",
       "Respondent                                                                      \n",
       "201         I am a developer by profession      Yes  27.0         18      NaN   \n",
       "569         I am a developer by profession       No  32.0         22  Monthly   \n",
       "634         I am a developer by profession      Yes  25.0         18  Monthly   \n",
       "763         I am a developer by profession      Yes   NaN         15      NaN   \n",
       "830         I am a developer by profession      Yes  25.0         22      NaN   \n",
       "...                                    ...      ...   ...        ...      ...   \n",
       "22462                                  NaN      Yes  22.0         16      NaN   \n",
       "47832                                  NaN      Yes   NaN        NaN      NaN   \n",
       "55211                                  NaN      Yes   NaN         31      NaN   \n",
       "55815                                  NaN      Yes   NaN         10      NaN   \n",
       "61983                                  NaN      Yes   NaN         25      NaN   \n",
       "\n",
       "            CompTotal  ConvertedComp   Country     CurrencyDesc  \\\n",
       "Respondent                                                        \n",
       "201               NaN            NaN  Pakistan  Pakistani rupee   \n",
       "569          220000.0        17124.0  Pakistan  Pakistani rupee   \n",
       "634            2500.0          192.0  Pakistan  Pakistani rupee   \n",
       "763               NaN            NaN  Pakistan              NaN   \n",
       "830               NaN            NaN  Pakistan  Pakistani rupee   \n",
       "...               ...            ...       ...              ...   \n",
       "22462             NaN            NaN  Pakistan              NaN   \n",
       "47832             NaN            NaN  Pakistan              NaN   \n",
       "55211             NaN            NaN  Pakistan              NaN   \n",
       "55815             NaN            NaN  Pakistan              NaN   \n",
       "61983             NaN            NaN  Pakistan              NaN   \n",
       "\n",
       "           CurrencySymbol                             DatabaseDesireNextYear  \\\n",
       "Respondent                                                                     \n",
       "201                   PKR  Couchbase;Elasticsearch;Firebase;MongoDB;MySQL...   \n",
       "569                   PKR                             Firebase;MongoDB;Redis   \n",
       "634                   PKR                  Microsoft SQL Server;MySQL;SQLite   \n",
       "763                   NaN                                                NaN   \n",
       "830                   PKR                               Microsoft SQL Server   \n",
       "...                   ...                                                ...   \n",
       "22462                 NaN                                      MongoDB;MySQL   \n",
       "47832                 NaN                                                NaN   \n",
       "55211                 NaN                                          Cassandra   \n",
       "55815                 NaN                                              MySQL   \n",
       "61983                 NaN                         Microsoft SQL Server;MySQL   \n",
       "\n",
       "                           DatabaseWorkedWith  \\\n",
       "Respondent                                      \n",
       "201              Couchbase;MongoDB;PostgreSQL   \n",
       "569                                       NaN   \n",
       "634         Microsoft SQL Server;MySQL;SQLite   \n",
       "763                     Firebase;MySQL;SQLite   \n",
       "830                      Microsoft SQL Server   \n",
       "...                                       ...   \n",
       "22462                           MongoDB;MySQL   \n",
       "47832                                     NaN   \n",
       "55211                               Cassandra   \n",
       "55815                                   MySQL   \n",
       "61983                                     NaN   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "201         Developer, back-end;Developer, desktop or ente...   \n",
       "569                Developer, front-end;Developer, full-stack   \n",
       "634         Academic researcher;Developer, desktop or ente...   \n",
       "763                                                       NaN   \n",
       "830             Data scientist or machine learning specialist   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                  Database administrator   \n",
       "61983                                Data or business analyst   \n",
       "\n",
       "                                                      EdLevel  \\\n",
       "Respondent                                                      \n",
       "201              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "569              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "634              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "763              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "830              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832            Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "55211                      Professional degree (JD, MD, etc.)   \n",
       "55815                                                     NaN   \n",
       "61983       Secondary school (e.g. American high school, G...   \n",
       "\n",
       "                                                   Employment  \\\n",
       "Respondent                                                      \n",
       "201                                        Employed full-time   \n",
       "569                                        Employed full-time   \n",
       "634         Independent contractor, freelancer, or self-em...   \n",
       "763                                                   Student   \n",
       "830                                        Employed full-time   \n",
       "...                                                       ...   \n",
       "22462                                                 Student   \n",
       "47832                                      Employed part-time   \n",
       "55211                                                 Student   \n",
       "55815                                      Employed part-time   \n",
       "61983                                      Employed full-time   \n",
       "\n",
       "                  Ethnicity Gender  \\\n",
       "Respondent                           \n",
       "201             South Asian    Man   \n",
       "569             South Asian    Man   \n",
       "634              East Asian    Man   \n",
       "763                     NaN    Man   \n",
       "830             South Asian    Man   \n",
       "...                     ...    ...   \n",
       "22462       Southeast Asian    Man   \n",
       "47832                   NaN    NaN   \n",
       "55211        Middle Eastern    Man   \n",
       "55815                   NaN    NaN   \n",
       "61983            East Asian    Man   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "201         Flex time or a flexible schedule;How widely us...   \n",
       "569         Languages, frameworks, and other technologies ...   \n",
       "634                          Flex time or a flexible schedule   \n",
       "763         Languages, frameworks, and other technologies ...   \n",
       "830         Industry that I’d be working in;Remote work op...   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                                     NaN   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                                        JobSat  \\\n",
       "Respondent                                       \n",
       "201                         Slightly satisfied   \n",
       "569                      Slightly dissatisfied   \n",
       "634         Neither satisfied nor dissatisfied   \n",
       "763                                        NaN   \n",
       "830         Neither satisfied nor dissatisfied   \n",
       "...                                        ...   \n",
       "22462                                      NaN   \n",
       "47832                                      NaN   \n",
       "55211                                      NaN   \n",
       "55815                                      NaN   \n",
       "61983                                      NaN   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "201         I’m not actively looking, but I am open to new...   \n",
       "569                           I am actively looking for a job   \n",
       "634         I’m not actively looking, but I am open to new...   \n",
       "763                           I am actively looking for a job   \n",
       "830         I’m not actively looking, but I am open to new...   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                                     NaN   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         Dart;Go;HTML/CSS;Java;JavaScript;Python;Rust;T...   \n",
       "569                                 JavaScript;SQL;TypeScript   \n",
       "634                                                   C#;Java   \n",
       "763                                                         C   \n",
       "830                                              Python;Scala   \n",
       "...                                                       ...   \n",
       "22462                                C#;JavaScript;Python;SQL   \n",
       "47832                                                     NaN   \n",
       "55211                                                Assembly   \n",
       "55815                                          C++;JavaScript   \n",
       "61983                                           HTML/CSS;Java   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "201         Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...   \n",
       "569                                       HTML/CSS;JavaScript   \n",
       "634                                                   C#;Java   \n",
       "763                 C;HTML/CSS;Java;JavaScript;PHP;Python;SQL   \n",
       "830                                                  Python;R   \n",
       "...                                                       ...   \n",
       "22462              C#;HTML/CSS;Java;JavaScript;PHP;Python;SQL   \n",
       "47832                                                     NaN   \n",
       "55211                                                Assembly   \n",
       "55815                                          C++;JavaScript   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                                       MiscTechDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         .NET Core;Flutter;Node.js;Pandas;React Native;...   \n",
       "569                                                   Node.js   \n",
       "634                                                      .NET   \n",
       "763                                                       NaN   \n",
       "830         Apache Spark;Hadoop;Keras;TensorFlow;Torch/PyT...   \n",
       "...                                                       ...   \n",
       "22462                          .NET Core;Node.js;React Native   \n",
       "47832                                                     NaN   \n",
       "55211                                                    .NET   \n",
       "55815                                                    .NET   \n",
       "61983                                      .NET;Unreal Engine   \n",
       "\n",
       "           MiscTechWorkedWith  \\\n",
       "Respondent                      \n",
       "201           Cordova;Node.js   \n",
       "569                       NaN   \n",
       "634                      .NET   \n",
       "763                   Node.js   \n",
       "830          Keras;TensorFlow   \n",
       "...                       ...   \n",
       "22462                 Node.js   \n",
       "47832                     NaN   \n",
       "55211                    .NET   \n",
       "55815                    .NET   \n",
       "61983                     NaN   \n",
       "\n",
       "                                 NEWCollabToolsDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         Confluence;Jira;Github;Trello;Google Suite (Do...   \n",
       "569         Jira;Github;Slack;Trello;Google Suite (Docs, M...   \n",
       "634                                                    Github   \n",
       "763                                                       NaN   \n",
       "830                                                    Github   \n",
       "...                                                       ...   \n",
       "22462                                                  Github   \n",
       "47832                                                     NaN   \n",
       "55211                          Google Suite (Docs, Meet, etc)   \n",
       "55815                                      Facebook Workplace   \n",
       "61983                                        Confluence;Slack   \n",
       "\n",
       "                                     NEWCollabToolsWorkedWith NEWDevOps  \\\n",
       "Respondent                                                                \n",
       "201         Confluence;Jira;Github;Gitlab;Trello;Google Su...        No   \n",
       "569         Jira;Github;Slack;Trello;Google Suite (Docs, M...       Yes   \n",
       "634                                                    Github  Not sure   \n",
       "763                                                    Github       NaN   \n",
       "830                                                    Github        No   \n",
       "...                                                       ...       ...   \n",
       "22462                                                  Github       NaN   \n",
       "47832                                                     NaN       NaN   \n",
       "55211                          Google Suite (Docs, Meet, etc)       NaN   \n",
       "55815                                      Facebook Workplace       NaN   \n",
       "61983                                                     NaN       NaN   \n",
       "\n",
       "                   NEWDevOpsImpt           NEWEdImpt  \\\n",
       "Respondent                                             \n",
       "201          Extremely important      Very important   \n",
       "569          Extremely important  Somewhat important   \n",
       "634         Not at all important                 NaN   \n",
       "763                          NaN                 NaN   \n",
       "830           Not very important  Somewhat important   \n",
       "...                          ...                 ...   \n",
       "22462                        NaN                 NaN   \n",
       "47832                        NaN    Fairly important   \n",
       "55211                        NaN                 NaN   \n",
       "55815                        NaN      Very important   \n",
       "61983                        NaN      Very important   \n",
       "\n",
       "                                                   NEWJobHunt  \\\n",
       "Respondent                                                      \n",
       "201         Curious about other opportunities;Better compe...   \n",
       "569         Curious about other opportunities;Better compe...   \n",
       "634         Better compensation;Trouble with my direct man...   \n",
       "763                                              Just because   \n",
       "830         Having a bad day (or week or month) at work;Be...   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                                     NaN   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                                           NEWJobHuntResearch  \\\n",
       "Respondent                                                      \n",
       "201         Read company media, such as employee blogs or ...   \n",
       "569         Read company media, such as employee blogs or ...   \n",
       "634         Directly asking current or past employees at t...   \n",
       "763                      Personal network - friends or family   \n",
       "830         Read company media, such as employee blogs or ...   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                                     NaN   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                        NEWLearn NEWOffTopic                NEWOnboardGood  \\\n",
       "Respondent                                                                   \n",
       "201             Every few months          No                           Yes   \n",
       "569             Every few months          No  Onboarding? What onboarding?   \n",
       "634         Once every few years         Yes  Onboarding? What onboarding?   \n",
       "763             Every few months         NaN                           NaN   \n",
       "830             Every few months          No  Onboarding? What onboarding?   \n",
       "...                          ...         ...                           ...   \n",
       "22462                Once a year    Not sure                           NaN   \n",
       "47832                        NaN         NaN                           NaN   \n",
       "55211                        NaN         NaN                           NaN   \n",
       "55815           Every few months         NaN                           NaN   \n",
       "61983       Once every few years         NaN                           NaN   \n",
       "\n",
       "           NEWOtherComms                                        NEWOvertime  \\\n",
       "Respondent                                                                    \n",
       "201                  Yes  Occasionally: 1-2 days per quarter but less th...   \n",
       "569                   No                  Rarely: 1-2 days per year or less   \n",
       "634                   No  Occasionally: 1-2 days per quarter but less th...   \n",
       "763                   No                                                NaN   \n",
       "830                   No  Sometimes: 1-2 days per month but less than we...   \n",
       "...                  ...                                                ...   \n",
       "22462                NaN                                                NaN   \n",
       "47832                NaN                                                NaN   \n",
       "55211                NaN                                                NaN   \n",
       "55815                NaN                                                NaN   \n",
       "61983                NaN                                                NaN   \n",
       "\n",
       "                                          NEWPurchaseResearch  \\\n",
       "Respondent                                                      \n",
       "201         Start a free trial;Ask developers I know/work ...   \n",
       "569         Ask developers I know/work with;Visit develope...   \n",
       "634                                        Start a free trial   \n",
       "763                                        Start a free trial   \n",
       "830                                                       NaN   \n",
       "...                                                       ...   \n",
       "22462       Start a free trial;Visit developer communities...   \n",
       "47832                                                     NaN   \n",
       "55211                                      Start a free trial   \n",
       "55815       Start a free trial;Ask developers I know/work ...   \n",
       "61983                                      Start a free trial   \n",
       "\n",
       "                NEWPurpleLink  \\\n",
       "Respondent                      \n",
       "201         Hello, old friend   \n",
       "569                   Annoyed   \n",
       "634                   Annoyed   \n",
       "763         Hello, old friend   \n",
       "830         Hello, old friend   \n",
       "...                       ...   \n",
       "22462             Indifferent   \n",
       "47832                     NaN   \n",
       "55211                 Annoyed   \n",
       "55815                  Amused   \n",
       "61983       Hello, old friend   \n",
       "\n",
       "                                                   NEWSOSites  \\\n",
       "Respondent                                                      \n",
       "201         Stack Overflow (public Q&A for anyone who code...   \n",
       "569         Stack Overflow (public Q&A for anyone who code...   \n",
       "634          Stack Overflow (public Q&A for anyone who codes)   \n",
       "763                     Stack Overflow Jobs (for job seekers)   \n",
       "830          Stack Overflow (public Q&A for anyone who codes)   \n",
       "...                                                       ...   \n",
       "22462       Stack Overflow (public Q&A for anyone who code...   \n",
       "47832                 I have never visited any of these sites   \n",
       "55211                 I have never visited any of these sites   \n",
       "55815                   Stack Overflow Jobs (for job seekers)   \n",
       "61983                   Stack Overflow Jobs (for job seekers)   \n",
       "\n",
       "                                                     NEWStuck    OpSys  \\\n",
       "Respondent                                                               \n",
       "201         Play games;Call a coworker or friend;Visit Sta...    MacOS   \n",
       "569         Call a coworker or friend;Visit Stack Overflow...    MacOS   \n",
       "634                                      Visit Stack Overflow  Windows   \n",
       "763                              Watch help / tutorial videos  Windows   \n",
       "830         Visit Stack Overflow;Watch help / tutorial vid...    MacOS   \n",
       "...                                                       ...      ...   \n",
       "22462       Visit Stack Overflow;Watch help / tutorial videos  Windows   \n",
       "47832                                                     NaN  Windows   \n",
       "55211                                                     NaN  Windows   \n",
       "55815       Meditate;Play games;Call a coworker or friend;...  Windows   \n",
       "61983                                    Visit Stack Overflow  Windows   \n",
       "\n",
       "                                                      OrgSize  \\\n",
       "Respondent                                                      \n",
       "201                                        20 to 99 employees   \n",
       "569                                      100 to 499 employees   \n",
       "634         Just me - I am a freelancer, sole proprietor, ...   \n",
       "763                                                       NaN   \n",
       "830                                  10,000 or more employees   \n",
       "...                                                       ...   \n",
       "22462                                                     NaN   \n",
       "47832                                                     NaN   \n",
       "55211                                                     NaN   \n",
       "55815                                                     NaN   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         AWS;Docker;Google Cloud Platform;Kubernetes;Li...   \n",
       "569                                                     MacOS   \n",
       "634                                                   Windows   \n",
       "763                                                       NaN   \n",
       "830                                                       NaN   \n",
       "...                                                       ...   \n",
       "22462                              Android;Heroku;iOS;Windows   \n",
       "47832                                                     NaN   \n",
       "55211                                   Google Cloud Platform   \n",
       "55815                                           Android;Linux   \n",
       "61983                                   Google Cloud Platform   \n",
       "\n",
       "                                    PlatformWorkedWith  \\\n",
       "Respondent                                               \n",
       "201         Android;Arduino;AWS;Docker;iOS;Linux;MacOS   \n",
       "569                                              MacOS   \n",
       "634                                            Windows   \n",
       "763                                            Android   \n",
       "830                                                NaN   \n",
       "...                                                ...   \n",
       "22462                                   Heroku;Windows   \n",
       "47832                                              NaN   \n",
       "55211                            Google Cloud Platform   \n",
       "55815                                    Android;Linux   \n",
       "61983                                          Android   \n",
       "\n",
       "                                PurchaseWhat                Sexuality  \\\n",
       "Respondent                                                              \n",
       "201                    I have some influence  Straight / Heterosexual   \n",
       "569         I have a great deal of influence  Straight / Heterosexual   \n",
       "634                                      NaN  Straight / Heterosexual   \n",
       "763                                      NaN                      NaN   \n",
       "830            I have little or no influence  Straight / Heterosexual   \n",
       "...                                      ...                      ...   \n",
       "22462                                    NaN  Straight / Heterosexual   \n",
       "47832                                    NaN                      NaN   \n",
       "55211                                    NaN                      NaN   \n",
       "55815                                    NaN                      NaN   \n",
       "61983                                    NaN                      NaN   \n",
       "\n",
       "           SOAccount           SOComm                           SOPartFreq  \\\n",
       "Respondent                                                                   \n",
       "201              Yes  Yes, definitely                Daily or almost daily   \n",
       "569              Yes    Yes, somewhat      A few times per month or weekly   \n",
       "634              Yes    Yes, somewhat      A few times per month or weekly   \n",
       "763              NaN              NaN                                  NaN   \n",
       "830              Yes  Yes, definitely  Less than once per month or monthly   \n",
       "...              ...              ...                                  ...   \n",
       "22462            Yes  Yes, definitely  Less than once per month or monthly   \n",
       "47832            NaN              NaN                                  NaN   \n",
       "55211            NaN              NaN                                  NaN   \n",
       "55815            NaN              NaN                                  NaN   \n",
       "61983            NaN              NaN                                  NaN   \n",
       "\n",
       "                                SOVisitFreq                  SurveyEase  \\\n",
       "Respondent                                                                \n",
       "201                  Multiple times per day                        Easy   \n",
       "569                   Daily or almost daily  Neither easy nor difficult   \n",
       "634                  Multiple times per day                        Easy   \n",
       "763                                     NaN                        Easy   \n",
       "830                  Multiple times per day  Neither easy nor difficult   \n",
       "...                                     ...                         ...   \n",
       "22462       A few times per month or weekly                        Easy   \n",
       "47832                                   NaN                         NaN   \n",
       "55211                                   NaN                        Easy   \n",
       "55815                                   NaN                        Easy   \n",
       "61983                                   NaN  Neither easy nor difficult   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "201         Appropriate in length    No   \n",
       "569         Appropriate in length    No   \n",
       "634                      Too long    No   \n",
       "763                     Too short    No   \n",
       "830         Appropriate in length    No   \n",
       "...                           ...   ...   \n",
       "22462       Appropriate in length    No   \n",
       "47832                         NaN   NaN   \n",
       "55211                   Too short   Yes   \n",
       "55815                    Too long    No   \n",
       "61983       Appropriate in length    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "201         Computer science, computer engineering, or sof...   \n",
       "569         Computer science, computer engineering, or sof...   \n",
       "634         Information systems, information technology, o...   \n",
       "763         Computer science, computer engineering, or sof...   \n",
       "830                                 Mathematics or statistics   \n",
       "...                                                       ...   \n",
       "22462       Computer science, computer engineering, or sof...   \n",
       "47832       A natural science (such as biology, chemistry,...   \n",
       "55211       Another engineering discipline (such as civil,...   \n",
       "55815       Another engineering discipline (such as civil,...   \n",
       "61983                                                     NaN   \n",
       "\n",
       "                            WebframeDesireNextYear  \\\n",
       "Respondent                                           \n",
       "201         Angular;Django;Express;React.js;Spring   \n",
       "569                 Express;jQuery;React.js;Vue.js   \n",
       "634                                        ASP.NET   \n",
       "763                                            NaN   \n",
       "830                                            NaN   \n",
       "...                                            ...   \n",
       "22462                ASP.NET Core;Express;React.js   \n",
       "47832                                          NaN   \n",
       "55211                                      Angular   \n",
       "55815                                          NaN   \n",
       "61983                                 Django;Flask   \n",
       "\n",
       "                                  WebframeWorkedWith  \\\n",
       "Respondent                                             \n",
       "201         Angular;Angular.js;Express;jQuery;Spring   \n",
       "569                                           jQuery   \n",
       "634                                          ASP.NET   \n",
       "763                                          Laravel   \n",
       "830                                              NaN   \n",
       "...                                              ...   \n",
       "22462                                 Express;jQuery   \n",
       "47832                                            NaN   \n",
       "55211                                        Angular   \n",
       "55815                                        Express   \n",
       "61983                                            NaN   \n",
       "\n",
       "                                      WelcomeChange  WorkWeekHrs  \\\n",
       "Respondent                                                         \n",
       "201         Just as welcome now as I felt last year         40.0   \n",
       "569           A lot less welcome now than last year         40.0   \n",
       "634         Just as welcome now as I felt last year         42.0   \n",
       "763                                             NaN          NaN   \n",
       "830         Just as welcome now as I felt last year         40.0   \n",
       "...                                             ...          ...   \n",
       "22462       Just as welcome now as I felt last year          NaN   \n",
       "47832                                           NaN          NaN   \n",
       "55211                                           NaN          NaN   \n",
       "55815                                           NaN          NaN   \n",
       "61983                                           NaN          NaN   \n",
       "\n",
       "                   YearsCode YearsCodePro  \n",
       "Respondent                                 \n",
       "201                        9            4  \n",
       "569                        8            6  \n",
       "634                        6            3  \n",
       "763                       14          NaN  \n",
       "830                        4            2  \n",
       "...                      ...          ...  \n",
       "22462                      6          NaN  \n",
       "47832                    NaN          NaN  \n",
       "55211                      6          NaN  \n",
       "55815       Less than 1 year            4  \n",
       "61983       Less than 1 year            3  \n",
       "\n",
       "[809 rows x 60 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp.get_group(\"Pakistan\") # grouped by country name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# another way to group by country name using filter method\n",
    "fltrpak = df[\"Country\"] == \"Pakistan\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Windows        424\n",
       "Linux-based    157\n",
       "MacOS           87\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[fltrpak][\"OpSys\"].value_counts()\n",
    "# counting operating system for one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country      OpSys      \n",
       "Afghanistan  Windows        31\n",
       "             Linux-based     8\n",
       "             MacOS           5\n",
       "Albania      Windows        24\n",
       "             MacOS           7\n",
       "                            ..\n",
       "Zambia       MacOS           2\n",
       "             Linux-based     1\n",
       "Zimbabwe     Windows        18\n",
       "             Linux-based     5\n",
       "             MacOS           3\n",
       "Name: OpSys, Length: 488, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp[\"OpSys\"].value_counts()\n",
    "# checking operating system of all the countries by group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country      OpSys      \n",
       "Afghanistan  Windows         31\n",
       "             Linux-based      8\n",
       "             MacOS            5\n",
       "Albania      Windows         24\n",
       "             MacOS            7\n",
       "             Linux-based      6\n",
       "Algeria      Windows         44\n",
       "             Linux-based     25\n",
       "             MacOS            5\n",
       "             BSD              1\n",
       "Andorra      Linux-based      4\n",
       "             Windows          2\n",
       "             BSD              1\n",
       "Angola       Windows          3\n",
       "             Linux-based      1\n",
       "Argentina    Windows        142\n",
       "             Linux-based    129\n",
       "             MacOS           75\n",
       "Armenia      Linux-based     21\n",
       "             Windows         20\n",
       "             MacOS           10\n",
       "Australia    Windows        513\n",
       "             MacOS          387\n",
       "             Linux-based    211\n",
       "Austria      Windows        274\n",
       "             Linux-based    154\n",
       "             MacOS           76\n",
       "Azerbaijan   Windows         25\n",
       "             Linux-based      9\n",
       "             MacOS            5\n",
       "Bahamas      MacOS            2\n",
       "Bahrain      Windows          5\n",
       "             MacOS            3\n",
       "Bangladesh   Windows        330\n",
       "             Linux-based    119\n",
       "             MacOS           50\n",
       "             BSD              1\n",
       "Barbados     MacOS            2\n",
       "             Linux-based      1\n",
       "             Windows          1\n",
       "Belarus      Windows         65\n",
       "             Linux-based     34\n",
       "             MacOS           18\n",
       "Belgium      Windows        248\n",
       "             Linux-based     89\n",
       "             MacOS           72\n",
       "Belize       Windows          3\n",
       "Benin        Windows          4\n",
       "             Linux-based      3\n",
       "             MacOS            1\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp[\"OpSys\"].value_counts().head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "countrygrp2 = df.groupby([\"Country\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x0000022782ECC640>"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DevType</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Gender</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>NEWCollabToolsDesireNextYear</th>\n",
       "      <th>NEWCollabToolsWorkedWith</th>\n",
       "      <th>NEWDevOps</th>\n",
       "      <th>NEWDevOpsImpt</th>\n",
       "      <th>NEWEdImpt</th>\n",
       "      <th>NEWJobHunt</th>\n",
       "      <th>NEWJobHuntResearch</th>\n",
       "      <th>NEWLearn</th>\n",
       "      <th>NEWOffTopic</th>\n",
       "      <th>NEWOnboardGood</th>\n",
       "      <th>NEWOtherComms</th>\n",
       "      <th>NEWOvertime</th>\n",
       "      <th>NEWPurchaseResearch</th>\n",
       "      <th>NEWPurpleLink</th>\n",
       "      <th>NEWSOSites</th>\n",
       "      <th>NEWStuck</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>I used to be a developer by profession, but no...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>31.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MySQL;PostgreSQL</td>\n",
       "      <td>MySQL;PostgreSQL;Redis;SQLite</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java;Ruby;Scala</td>\n",
       "      <td>HTML/CSS;Ruby;SQL</td>\n",
       "      <td>Ansible;Chef</td>\n",
       "      <td>Ansible</td>\n",
       "      <td>Github;Google Suite (Docs, Meet, etc)</td>\n",
       "      <td>Confluence;Jira;Github;Slack;Google Suite (Doc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Docker;Google Cloud Platform;Heroku;Linux;Windows</td>\n",
       "      <td>AWS;Docker;Linux;MacOS;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Ruby on Rails</td>\n",
       "      <td>Ruby on Rails</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>36.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>MongoDB</td>\n",
       "      <td>MariaDB;MySQL;Redis</td>\n",
       "      <td>Developer, back-end;Developer, desktop or ente...</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Remote work options;Opportunities for professi...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>JavaScript</td>\n",
       "      <td>Python;SQL</td>\n",
       "      <td>Unity 3D</td>\n",
       "      <td>Ansible</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Confluence;Jira;Github;Slack;Microsoft Teams;G...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Not at all important/not necessary</td>\n",
       "      <td>Curious about other opportunities;Better compe...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Play games;Call a coworker or friend;Visit Sta...</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>iOS;Slack Apps and Integrations</td>\n",
       "      <td>Docker</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No, not really</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;React.js;Vue.js</td>\n",
       "      <td>Flask</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>39.0</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>13</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>Firebase;Microsoft SQL Server</td>\n",
       "      <td>Firebase;Microsoft SQL Server</td>\n",
       "      <td>Developer, desktop or enterprise applications;...</td>\n",
       "      <td>Associate degree (A.A., A.S., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Industry that I’d be working in;Flex time or a...</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>HTML/CSS;JavaScript;SQL;TypeScript</td>\n",
       "      <td>HTML/CSS;JavaScript;SQL;TypeScript</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>Confluence;Jira;Github;Microsoft Teams;Google ...</td>\n",
       "      <td>Confluence;Jira;Github;Microsoft Teams</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Wanting to share accomplishments with a wider ...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>100 to 499 employees</td>\n",
       "      <td>Google Cloud Platform;Raspberry Pi;Windows</td>\n",
       "      <td>Google Cloud Platform;Windows</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>A few times per week</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Vue.js</td>\n",
       "      <td>Angular;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>Cassandra;Elasticsearch;MariaDB;PostgreSQL;Redis</td>\n",
       "      <td>Microsoft SQL Server;PostgreSQL</td>\n",
       "      <td>Developer, full-stack</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Industry that I’d be working in;Languages, fra...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>C#;Go;Haskell;HTML/CSS;JavaScript;Python;Ruby;...</td>\n",
       "      <td>C#;HTML/CSS;JavaScript;Python;SQL;VBA</td>\n",
       "      <td>.NET Core;Teraform</td>\n",
       "      <td>.NET;Node.js</td>\n",
       "      <td>Github;Gitlab;Slack;Google Suite (Docs, Meet, ...</td>\n",
       "      <td>Github;Gitlab;Slack;Microsoft Teams;Google Sui...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>Having a bad day (or week or month) at work;Be...</td>\n",
       "      <td>Company reviews from third party sites (e.g. G...</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely: 1-2 days per year or less</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>Docker;Kubernetes;Microsoft Azure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No, not at all</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Gatsby;React.js;Vue.js</td>\n",
       "      <td>ASP.NET;Gatsby;jQuery;React.js;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>32.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>1260000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>Elasticsearch;PostgreSQL;Redis;SQLite</td>\n",
       "      <td>Elasticsearch;MariaDB;MySQL;Redis;SQLite</td>\n",
       "      <td>Developer, back-end</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>HTML/CSS;Perl</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Perl</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github;Slack</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Very important</td>\n",
       "      <td>Looking to relocate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once every few years</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Play games;Visit Stack Overflow;Do other work ...</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>100 to 499 employees</td>\n",
       "      <td>Linux</td>\n",
       "      <td>AWS;Linux</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>45.0</td>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58498</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>32.0</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Firebase;Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Firebase;Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Data or business analyst;Developer, back-end;S...</td>\n",
       "      <td>Some college/university study without earning ...</td>\n",
       "      <td>Independent contractor, freelancer, or self-em...</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>.NET;.NET Core;Apache Spark;Cordova;Flutter;No...</td>\n",
       "      <td>.NET;.NET Core;Apache Spark;Cordova;Flutter;No...</td>\n",
       "      <td>Github;Gitlab;Facebook Workplace;Slack;Microso...</td>\n",
       "      <td>Github;Gitlab;Facebook Workplace;Slack;Microso...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Visit developer communities...</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Exchange (public Q&amp;A for a variety of to...</td>\n",
       "      <td>Watch help / tutorial videos;Visit another dev...</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android;Google Cloud Platform;Linux;MacOS;Micr...</td>\n",
       "      <td>Android;Google Cloud Platform;Linux;MacOS;Micr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>ASP.NET;ASP.NET Core;Flask;Gatsby;jQuery;React...</td>\n",
       "      <td>ASP.NET;ASP.NET Core;Flask;Gatsby;jQuery;React...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58896</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>29.0</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Student</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Haskell</td>\n",
       "      <td>Haskell</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gitlab;Slack</td>\n",
       "      <td>Github;Gitlab;Slack</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ask developers I know/work with;Visit develope...</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Play games;Call a coworker or friend;Visit Sta...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gay or Lesbian;Queer</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per week</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60931</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MariaDB;MySQL;PostgreSQL</td>\n",
       "      <td>MariaDB;MySQL</td>\n",
       "      <td>System administrator</td>\n",
       "      <td>Some college/university study without earning ...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bash/Shell/PowerShell;C;C#;C++;PHP;Python</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;PHP</td>\n",
       "      <td>Unity 3D;Unreal Engine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github;Stack Overflow for Teams</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not at all important/not necessary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Visit developer communities...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Play games;Visit Stack Overflow;Watch help / t...</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android;Arduino;Linux;Raspberry Pi;Windows</td>\n",
       "      <td>WordPress</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Web development or web design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drupal</td>\n",
       "      <td>Not applicable - I did not use Stack Overflow ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63077</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Not employed, but looking for work</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C++;Rust;SQL</td>\n",
       "      <td>C++;HTML/CSS;Java;JavaScript;Python;SQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No, not really</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>A few times per week</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64858</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Senior executive/VP</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a decade</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Call a coworker or friend</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12469 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "5           I used to be a developer by profession, but no...      Yes  31.0   \n",
       "8                              I am a developer by profession      Yes  36.0   \n",
       "14                             I am a developer by profession      Yes  27.0   \n",
       "17                             I am a developer by profession      Yes  25.0   \n",
       "18                             I am a developer by profession      Yes  32.0   \n",
       "...                                                       ...      ...   ...   \n",
       "58498                                                     NaN      Yes  32.0   \n",
       "58896                                                     NaN      Yes  29.0   \n",
       "60931                                                     NaN      Yes   NaN   \n",
       "63077                                                     NaN      Yes   NaN   \n",
       "64858                                                     NaN      Yes   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  ConvertedComp        Country  \\\n",
       "Respondent                                                                \n",
       "5                  16      NaN        NaN            NaN  United States   \n",
       "8                  12   Yearly   116000.0       116000.0  United States   \n",
       "14                 13   Yearly    66000.0        66000.0  United States   \n",
       "17                 14   Yearly    79000.0        79000.0  United States   \n",
       "18                 12  Monthly   105000.0      1260000.0  United States   \n",
       "...               ...      ...        ...            ...            ...   \n",
       "58498              23      NaN        NaN            NaN  United States   \n",
       "58896              10      NaN        NaN            NaN  United States   \n",
       "60931              17      NaN        NaN            NaN  United States   \n",
       "63077              20      NaN        NaN            NaN  United States   \n",
       "64858              16      NaN        NaN            NaN  United States   \n",
       "\n",
       "                    CurrencyDesc CurrencySymbol  \\\n",
       "Respondent                                        \n",
       "5                            NaN            NaN   \n",
       "8           United States dollar            USD   \n",
       "14          United States dollar            USD   \n",
       "17          United States dollar            USD   \n",
       "18          United States dollar            USD   \n",
       "...                          ...            ...   \n",
       "58498                        NaN            NaN   \n",
       "58896                        NaN            NaN   \n",
       "60931                        NaN            NaN   \n",
       "63077                        NaN            NaN   \n",
       "64858                        NaN            NaN   \n",
       "\n",
       "                                      DatabaseDesireNextYear  \\\n",
       "Respondent                                                     \n",
       "5                                           MySQL;PostgreSQL   \n",
       "8                                                    MongoDB   \n",
       "14                             Firebase;Microsoft SQL Server   \n",
       "17          Cassandra;Elasticsearch;MariaDB;PostgreSQL;Redis   \n",
       "18                     Elasticsearch;PostgreSQL;Redis;SQLite   \n",
       "...                                                      ...   \n",
       "58498             Firebase;Microsoft SQL Server;MySQL;SQLite   \n",
       "58896                                                    NaN   \n",
       "60931                               MariaDB;MySQL;PostgreSQL   \n",
       "63077                                                  MySQL   \n",
       "64858                                                    NaN   \n",
       "\n",
       "                                    DatabaseWorkedWith  \\\n",
       "Respondent                                               \n",
       "5                        MySQL;PostgreSQL;Redis;SQLite   \n",
       "8                                  MariaDB;MySQL;Redis   \n",
       "14                       Firebase;Microsoft SQL Server   \n",
       "17                     Microsoft SQL Server;PostgreSQL   \n",
       "18            Elasticsearch;MariaDB;MySQL;Redis;SQLite   \n",
       "...                                                ...   \n",
       "58498       Firebase;Microsoft SQL Server;MySQL;SQLite   \n",
       "58896                                              NaN   \n",
       "60931                                    MariaDB;MySQL   \n",
       "63077                                            MySQL   \n",
       "64858                                              NaN   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "5                                                         NaN   \n",
       "8           Developer, back-end;Developer, desktop or ente...   \n",
       "14          Developer, desktop or enterprise applications;...   \n",
       "17                                      Developer, full-stack   \n",
       "18                                        Developer, back-end   \n",
       "...                                                       ...   \n",
       "58498       Data or business analyst;Developer, back-end;S...   \n",
       "58896                                                     NaN   \n",
       "60931                                    System administrator   \n",
       "63077                                                     NaN   \n",
       "64858                                     Senior executive/VP   \n",
       "\n",
       "                                                      EdLevel  \\\n",
       "Respondent                                                      \n",
       "5                Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "8                Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "14                        Associate degree (A.A., A.S., etc.)   \n",
       "17               Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "18               Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "...                                                       ...   \n",
       "58498       Some college/university study without earning ...   \n",
       "58896            Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "60931       Some college/university study without earning ...   \n",
       "63077            Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "64858         Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "\n",
       "                                                   Employment  \\\n",
       "Respondent                                                      \n",
       "5                                          Employed full-time   \n",
       "8                                          Employed full-time   \n",
       "14                                         Employed full-time   \n",
       "17                                         Employed full-time   \n",
       "18                                         Employed full-time   \n",
       "...                                                       ...   \n",
       "58498       Independent contractor, freelancer, or self-em...   \n",
       "58896                                                 Student   \n",
       "60931                                      Employed full-time   \n",
       "63077                      Not employed, but looking for work   \n",
       "64858                                      Employed full-time   \n",
       "\n",
       "                               Ethnicity Gender  \\\n",
       "Respondent                                        \n",
       "5           White or of European descent    Man   \n",
       "8           White or of European descent    Man   \n",
       "14          White or of European descent    Man   \n",
       "17          White or of European descent    Man   \n",
       "18          White or of European descent    Man   \n",
       "...                                  ...    ...   \n",
       "58498       White or of European descent    Man   \n",
       "58896       White or of European descent    Man   \n",
       "60931                                NaN    Man   \n",
       "63077                                NaN    NaN   \n",
       "64858                                NaN    NaN   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "5                                                         NaN   \n",
       "8           Remote work options;Opportunities for professi...   \n",
       "14          Industry that I’d be working in;Flex time or a...   \n",
       "17          Industry that I’d be working in;Languages, fra...   \n",
       "18          Languages, frameworks, and other technologies ...   \n",
       "...                                                       ...   \n",
       "58498                                                     NaN   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                           JobSat  \\\n",
       "Respondent                          \n",
       "5                             NaN   \n",
       "8           Slightly dissatisfied   \n",
       "14             Slightly satisfied   \n",
       "17          Slightly dissatisfied   \n",
       "18                 Very satisfied   \n",
       "...                           ...   \n",
       "58498                         NaN   \n",
       "58896                         NaN   \n",
       "60931                         NaN   \n",
       "63077                         NaN   \n",
       "64858                         NaN   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "5                                                         NaN   \n",
       "8           I’m not actively looking, but I am open to new...   \n",
       "14          I’m not actively looking, but I am open to new...   \n",
       "17          I’m not actively looking, but I am open to new...   \n",
       "18               I am not interested in new job opportunities   \n",
       "...                                                       ...   \n",
       "58498                                                     NaN   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "5                                             Java;Ruby;Scala   \n",
       "8                                                  JavaScript   \n",
       "14                         HTML/CSS;JavaScript;SQL;TypeScript   \n",
       "17          C#;Go;Haskell;HTML/CSS;JavaScript;Python;Ruby;...   \n",
       "18                                              HTML/CSS;Perl   \n",
       "...                                                       ...   \n",
       "58498       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "58896                                                 Haskell   \n",
       "60931               Bash/Shell/PowerShell;C;C#;C++;PHP;Python   \n",
       "63077                                            C++;Rust;SQL   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "5                                           HTML/CSS;Ruby;SQL   \n",
       "8                                                  Python;SQL   \n",
       "14                         HTML/CSS;JavaScript;SQL;TypeScript   \n",
       "17                      C#;HTML/CSS;JavaScript;Python;SQL;VBA   \n",
       "18                        Bash/Shell/PowerShell;HTML/CSS;Perl   \n",
       "...                                                       ...   \n",
       "58498       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "58896                                                 Haskell   \n",
       "60931                      Bash/Shell/PowerShell;HTML/CSS;PHP   \n",
       "63077                 C++;HTML/CSS;Java;JavaScript;Python;SQL   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                       MiscTechDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "5                                                Ansible;Chef   \n",
       "8                                                    Unity 3D   \n",
       "14                                                    Node.js   \n",
       "17                                         .NET Core;Teraform   \n",
       "18                                                        NaN   \n",
       "...                                                       ...   \n",
       "58498       .NET;.NET Core;Apache Spark;Cordova;Flutter;No...   \n",
       "58896                                                     NaN   \n",
       "60931                                  Unity 3D;Unreal Engine   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                           MiscTechWorkedWith  \\\n",
       "Respondent                                                      \n",
       "5                                                     Ansible   \n",
       "8                                                     Ansible   \n",
       "14                                                    Node.js   \n",
       "17                                               .NET;Node.js   \n",
       "18                                                        NaN   \n",
       "...                                                       ...   \n",
       "58498       .NET;.NET Core;Apache Spark;Cordova;Flutter;No...   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                 NEWCollabToolsDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "5                       Github;Google Suite (Docs, Meet, etc)   \n",
       "8                                                         NaN   \n",
       "14          Confluence;Jira;Github;Microsoft Teams;Google ...   \n",
       "17          Github;Gitlab;Slack;Google Suite (Docs, Meet, ...   \n",
       "18                                                     Github   \n",
       "...                                                       ...   \n",
       "58498       Github;Gitlab;Facebook Workplace;Slack;Microso...   \n",
       "58896                                            Gitlab;Slack   \n",
       "60931                         Github;Stack Overflow for Teams   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                     NEWCollabToolsWorkedWith NEWDevOps  \\\n",
       "Respondent                                                                \n",
       "5           Confluence;Jira;Github;Slack;Google Suite (Doc...       NaN   \n",
       "8           Confluence;Jira;Github;Slack;Microsoft Teams;G...       Yes   \n",
       "14                     Confluence;Jira;Github;Microsoft Teams       Yes   \n",
       "17          Github;Gitlab;Slack;Microsoft Teams;Google Sui...       Yes   \n",
       "18                                               Github;Slack  Not sure   \n",
       "...                                                       ...       ...   \n",
       "58498       Github;Gitlab;Facebook Workplace;Slack;Microso...       NaN   \n",
       "58896                                     Github;Gitlab;Slack       NaN   \n",
       "60931                                                  Github       NaN   \n",
       "63077                                                     NaN       NaN   \n",
       "64858                                                     NaN       NaN   \n",
       "\n",
       "                  NEWDevOpsImpt                           NEWEdImpt  \\\n",
       "Respondent                                                            \n",
       "5                           NaN                      Very important   \n",
       "8           Extremely important  Not at all important/not necessary   \n",
       "14          Extremely important                  Somewhat important   \n",
       "17          Extremely important                    Fairly important   \n",
       "18                      Neutral                      Very important   \n",
       "...                         ...                                 ...   \n",
       "58498                       NaN                      Very important   \n",
       "58896                       NaN                                 NaN   \n",
       "60931                       NaN  Not at all important/not necessary   \n",
       "63077                       NaN                    Fairly important   \n",
       "64858                       NaN                      Very important   \n",
       "\n",
       "                                                   NEWJobHunt  \\\n",
       "Respondent                                                      \n",
       "5                                                         NaN   \n",
       "8           Curious about other opportunities;Better compe...   \n",
       "14          Wanting to share accomplishments with a wider ...   \n",
       "17          Having a bad day (or week or month) at work;Be...   \n",
       "18                                        Looking to relocate   \n",
       "...                                                       ...   \n",
       "58498                                                     NaN   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                           NEWJobHuntResearch  \\\n",
       "Respondent                                                      \n",
       "5                                                         NaN   \n",
       "8           Read company media, such as employee blogs or ...   \n",
       "14          Read company media, such as employee blogs or ...   \n",
       "17          Company reviews from third party sites (e.g. G...   \n",
       "18                                                        NaN   \n",
       "...                                                       ...   \n",
       "58498                                                     NaN   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                        NEWLearn NEWOffTopic                NEWOnboardGood  \\\n",
       "Respondent                                                                   \n",
       "5                    Once a year          No                           NaN   \n",
       "8                    Once a year    Not sure                           Yes   \n",
       "14              Every few months          No                           Yes   \n",
       "17                   Once a year    Not sure                            No   \n",
       "18          Once every few years         Yes  Onboarding? What onboarding?   \n",
       "...                          ...         ...                           ...   \n",
       "58498                        NaN         NaN                           NaN   \n",
       "58896                Once a year          No                           NaN   \n",
       "60931                        NaN    Not sure                           NaN   \n",
       "63077                        NaN         NaN                           NaN   \n",
       "64858              Once a decade         NaN                           NaN   \n",
       "\n",
       "           NEWOtherComms                                        NEWOvertime  \\\n",
       "Respondent                                                                    \n",
       "5                    Yes                                                NaN   \n",
       "8                     No  Occasionally: 1-2 days per quarter but less th...   \n",
       "14                    No  Occasionally: 1-2 days per quarter but less th...   \n",
       "17                    No                  Rarely: 1-2 days per year or less   \n",
       "18                   Yes  Occasionally: 1-2 days per quarter but less th...   \n",
       "...                  ...                                                ...   \n",
       "58498                NaN                                                NaN   \n",
       "58896                NaN                                                NaN   \n",
       "60931                NaN                                                NaN   \n",
       "63077                NaN                                                NaN   \n",
       "64858                NaN                                                NaN   \n",
       "\n",
       "                                          NEWPurchaseResearch  \\\n",
       "Respondent                                                      \n",
       "5           Start a free trial;Ask developers I know/work ...   \n",
       "8           Start a free trial;Ask developers I know/work ...   \n",
       "14                                                        NaN   \n",
       "17                                                        NaN   \n",
       "18          Start a free trial;Ask developers I know/work ...   \n",
       "...                                                       ...   \n",
       "58498       Start a free trial;Visit developer communities...   \n",
       "58896       Ask developers I know/work with;Visit develope...   \n",
       "60931       Start a free trial;Visit developer communities...   \n",
       "63077                                                     NaN   \n",
       "64858                                      Start a free trial   \n",
       "\n",
       "                NEWPurpleLink  \\\n",
       "Respondent                      \n",
       "5           Hello, old friend   \n",
       "8           Hello, old friend   \n",
       "14                     Amused   \n",
       "17          Hello, old friend   \n",
       "18          Hello, old friend   \n",
       "...                       ...   \n",
       "58498                  Amused   \n",
       "58896                  Amused   \n",
       "60931       Hello, old friend   \n",
       "63077                     NaN   \n",
       "64858                  Amused   \n",
       "\n",
       "                                                   NEWSOSites  \\\n",
       "Respondent                                                      \n",
       "5           Stack Overflow (public Q&A for anyone who code...   \n",
       "8           Stack Overflow (public Q&A for anyone who code...   \n",
       "14          Stack Overflow (public Q&A for anyone who code...   \n",
       "17          Stack Overflow (public Q&A for anyone who code...   \n",
       "18          Stack Overflow (public Q&A for anyone who code...   \n",
       "...                                                       ...   \n",
       "58498       Stack Exchange (public Q&A for a variety of to...   \n",
       "58896       Stack Overflow (public Q&A for anyone who code...   \n",
       "60931        Stack Overflow (public Q&A for anyone who codes)   \n",
       "63077        Stack Overflow (public Q&A for anyone who codes)   \n",
       "64858        Stack Overflow (public Q&A for anyone who codes)   \n",
       "\n",
       "                                                     NEWStuck        OpSys  \\\n",
       "Respondent                                                                   \n",
       "5           Call a coworker or friend;Visit Stack Overflow...      Windows   \n",
       "8           Play games;Call a coworker or friend;Visit Sta...  Linux-based   \n",
       "14          Call a coworker or friend;Visit Stack Overflow...      Windows   \n",
       "17          Call a coworker or friend;Visit Stack Overflow...      Windows   \n",
       "18          Play games;Visit Stack Overflow;Do other work ...  Linux-based   \n",
       "...                                                       ...          ...   \n",
       "58498       Watch help / tutorial videos;Visit another dev...  Linux-based   \n",
       "58896       Play games;Call a coworker or friend;Visit Sta...        MacOS   \n",
       "60931       Play games;Visit Stack Overflow;Watch help / t...  Linux-based   \n",
       "63077                                                     NaN          NaN   \n",
       "64858                               Call a coworker or friend      Windows   \n",
       "\n",
       "                         OrgSize  \\\n",
       "Respondent                         \n",
       "5                            NaN   \n",
       "8             20 to 99 employees   \n",
       "14          100 to 499 employees   \n",
       "17            20 to 99 employees   \n",
       "18          100 to 499 employees   \n",
       "...                          ...   \n",
       "58498                        NaN   \n",
       "58896                        NaN   \n",
       "60931                        NaN   \n",
       "63077                        NaN   \n",
       "64858                        NaN   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "5           Docker;Google Cloud Platform;Heroku;Linux;Windows   \n",
       "8                             iOS;Slack Apps and Integrations   \n",
       "14                 Google Cloud Platform;Raspberry Pi;Windows   \n",
       "17                          Docker;Kubernetes;Microsoft Azure   \n",
       "18                                                      Linux   \n",
       "...                                                       ...   \n",
       "58498       Android;Google Cloud Platform;Linux;MacOS;Micr...   \n",
       "58896                                                     NaN   \n",
       "60931              Android;Arduino;Linux;Raspberry Pi;Windows   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                           PlatformWorkedWith  \\\n",
       "Respondent                                                      \n",
       "5                              AWS;Docker;Linux;MacOS;Windows   \n",
       "8                                                      Docker   \n",
       "14                              Google Cloud Platform;Windows   \n",
       "17                                                        NaN   \n",
       "18                                                  AWS;Linux   \n",
       "...                                                       ...   \n",
       "58498       Android;Google Cloud Platform;Linux;MacOS;Micr...   \n",
       "58896                                                     NaN   \n",
       "60931                                               WordPress   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                             PurchaseWhat                Sexuality SOAccount  \\\n",
       "Respondent                                                                     \n",
       "5                                     NaN  Straight / Heterosexual       Yes   \n",
       "8                   I have some influence  Straight / Heterosexual       Yes   \n",
       "14          I have little or no influence  Straight / Heterosexual       Yes   \n",
       "17          I have little or no influence  Straight / Heterosexual       Yes   \n",
       "18                  I have some influence  Straight / Heterosexual       Yes   \n",
       "...                                   ...                      ...       ...   \n",
       "58498                                 NaN  Straight / Heterosexual       NaN   \n",
       "58896                                 NaN     Gay or Lesbian;Queer       Yes   \n",
       "60931                                 NaN                      NaN       Yes   \n",
       "63077                                 NaN                      NaN       Yes   \n",
       "64858                                 NaN                      NaN       NaN   \n",
       "\n",
       "                     SOComm  \\\n",
       "Respondent                    \n",
       "5             Yes, somewhat   \n",
       "8            No, not really   \n",
       "14          Yes, definitely   \n",
       "17           No, not at all   \n",
       "18            Yes, somewhat   \n",
       "...                     ...   \n",
       "58498                   NaN   \n",
       "58896         Yes, somewhat   \n",
       "60931               Neutral   \n",
       "63077        No, not really   \n",
       "64858                   NaN   \n",
       "\n",
       "                                                   SOPartFreq  \\\n",
       "Respondent                                                      \n",
       "5                         Less than once per month or monthly   \n",
       "8                         Less than once per month or monthly   \n",
       "14                                       A few times per week   \n",
       "17          I have never participated in Q&A on Stack Over...   \n",
       "18          I have never participated in Q&A on Stack Over...   \n",
       "...                                                       ...   \n",
       "58498                                                     NaN   \n",
       "58896                                    A few times per week   \n",
       "60931       I have never participated in Q&A on Stack Over...   \n",
       "63077       I have never participated in Q&A on Stack Over...   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                    SOVisitFreq                  SurveyEase  \\\n",
       "Respondent                                                                    \n",
       "5               A few times per month or weekly                        Easy   \n",
       "8                        Multiple times per day                        Easy   \n",
       "14                       Multiple times per day  Neither easy nor difficult   \n",
       "17                        Daily or almost daily                        Easy   \n",
       "18                        Daily or almost daily  Neither easy nor difficult   \n",
       "...                                         ...                         ...   \n",
       "58498                                       NaN  Neither easy nor difficult   \n",
       "58896                     Daily or almost daily  Neither easy nor difficult   \n",
       "60931       Less than once per month or monthly  Neither easy nor difficult   \n",
       "63077                      A few times per week                         NaN   \n",
       "64858                                       NaN                         NaN   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "5                       Too short    No   \n",
       "8           Appropriate in length    No   \n",
       "14          Appropriate in length    No   \n",
       "17          Appropriate in length    No   \n",
       "18          Appropriate in length    No   \n",
       "...                           ...   ...   \n",
       "58498       Appropriate in length    No   \n",
       "58896       Appropriate in length    No   \n",
       "60931                    Too long    No   \n",
       "63077                         NaN   NaN   \n",
       "64858                         NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "5           Computer science, computer engineering, or sof...   \n",
       "8           Computer science, computer engineering, or sof...   \n",
       "14          Computer science, computer engineering, or sof...   \n",
       "17          Computer science, computer engineering, or sof...   \n",
       "18          Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "58498                               Mathematics or statistics   \n",
       "58896       Computer science, computer engineering, or sof...   \n",
       "60931                           Web development or web design   \n",
       "63077       Computer science, computer engineering, or sof...   \n",
       "64858       Computer science, computer engineering, or sof...   \n",
       "\n",
       "                                       WebframeDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "5                                        Django;Ruby on Rails   \n",
       "8                                      Django;React.js;Vue.js   \n",
       "14                                             Angular;Vue.js   \n",
       "17                        ASP.NET Core;Gatsby;React.js;Vue.js   \n",
       "18                                                        NaN   \n",
       "...                                                       ...   \n",
       "58498       ASP.NET;ASP.NET Core;Flask;Gatsby;jQuery;React...   \n",
       "58896                                                     NaN   \n",
       "60931                                                     NaN   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                           WebframeWorkedWith  \\\n",
       "Respondent                                                      \n",
       "5                                               Ruby on Rails   \n",
       "8                                                       Flask   \n",
       "14                                             Angular;Vue.js   \n",
       "17                      ASP.NET;Gatsby;jQuery;React.js;Vue.js   \n",
       "18                                                        NaN   \n",
       "...                                                       ...   \n",
       "58498       ASP.NET;ASP.NET Core;Flask;Gatsby;jQuery;React...   \n",
       "58896                                                     NaN   \n",
       "60931                                                  Drupal   \n",
       "63077                                                     NaN   \n",
       "64858                                                     NaN   \n",
       "\n",
       "                                                WelcomeChange  WorkWeekHrs  \\\n",
       "Respondent                                                                   \n",
       "5                     Just as welcome now as I felt last year          NaN   \n",
       "8                     Just as welcome now as I felt last year         39.0   \n",
       "14                    Just as welcome now as I felt last year         40.0   \n",
       "17                    Just as welcome now as I felt last year         40.0   \n",
       "18                    Just as welcome now as I felt last year         45.0   \n",
       "...                                                       ...          ...   \n",
       "58498                                                     NaN          NaN   \n",
       "58896                 Just as welcome now as I felt last year          NaN   \n",
       "60931       Not applicable - I did not use Stack Overflow ...          NaN   \n",
       "63077                                                     NaN          NaN   \n",
       "64858                                                     NaN          NaN   \n",
       "\n",
       "           YearsCode      YearsCodePro  \n",
       "Respondent                              \n",
       "5                 15                 8  \n",
       "8                 17                13  \n",
       "14                 5                 1  \n",
       "17                 7                 3  \n",
       "18                19                12  \n",
       "...              ...               ...  \n",
       "58498              8  Less than 1 year  \n",
       "58896             29               NaN  \n",
       "60931              5               NaN  \n",
       "63077              4               NaN  \n",
       "64858             10  Less than 1 year  \n",
       "\n",
       "[12469 rows x 60 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2.get_group(\"United States\")\n",
    "# displaying country by groups"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country      OpSys      \n",
       "Afghanistan  Windows        31\n",
       "             Linux-based     8\n",
       "             MacOS           5\n",
       "Albania      Windows        24\n",
       "             MacOS           7\n",
       "                            ..\n",
       "Zambia       MacOS           2\n",
       "             Linux-based     1\n",
       "Zimbabwe     Windows        18\n",
       "             Linux-based     5\n",
       "             MacOS           3\n",
       "Name: OpSys, Length: 488, dtype: int64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OpSys\n",
       "Windows        424\n",
       "Linux-based    157\n",
       "MacOS           87\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts().loc[\"Pakistan\"]\n",
    "# operating system of one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OpSys\n",
       "Windows        4874\n",
       "MacOS          4082\n",
       "Linux-based    2445\n",
       "BSD               8\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts().loc[\"United States\"]\n",
    "# operating system of one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OpSys\n",
       "Windows        152\n",
       "MacOS           65\n",
       "Linux-based     64\n",
       "BSD              1\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts().loc[\"China\"]\n",
    "# operating system of one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OpSys\n",
       "Windows        3426\n",
       "Linux-based    2077\n",
       "MacOS          1158\n",
       "BSD               5\n",
       "Name: OpSys, dtype: int64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts().loc[\"India\"]\n",
    "# operating system of one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OpSys\n",
       "Windows        0.427207\n",
       "MacOS          0.357788\n",
       "Linux-based    0.214304\n",
       "BSD            0.000701\n",
       "Name: OpSys, dtype: float64"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"OpSys\"].value_counts(normalize = True).loc[\"United States\"]\n",
    "# operating system of one country persentage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>24.0</td>\n",
       "      <td>148290.125000</td>\n",
       "      <td>332705.942277</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4470.75</td>\n",
       "      <td>15163.5</td>\n",
       "      <td>23328.0</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>20.0</td>\n",
       "      <td>25611.000000</td>\n",
       "      <td>40946.849387</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10758.00</td>\n",
       "      <td>15900.0</td>\n",
       "      <td>25944.0</td>\n",
       "      <td>194580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>16.0</td>\n",
       "      <td>10362.812500</td>\n",
       "      <td>8802.055769</td>\n",
       "      <td>300.0</td>\n",
       "      <td>3849.00</td>\n",
       "      <td>9432.0</td>\n",
       "      <td>13284.0</td>\n",
       "      <td>36000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>2.0</td>\n",
       "      <td>88640.000000</td>\n",
       "      <td>74908.063972</td>\n",
       "      <td>35672.0</td>\n",
       "      <td>62156.00</td>\n",
       "      <td>88640.0</td>\n",
       "      <td>115124.0</td>\n",
       "      <td>141608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>2.0</td>\n",
       "      <td>5292.000000</td>\n",
       "      <td>627.910822</td>\n",
       "      <td>4848.0</td>\n",
       "      <td>5070.00</td>\n",
       "      <td>5292.0</td>\n",
       "      <td>5514.0</td>\n",
       "      <td>5736.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Venezuela, Bolivarian Republic of...</th>\n",
       "      <td>36.0</td>\n",
       "      <td>6280.611111</td>\n",
       "      <td>6714.752459</td>\n",
       "      <td>96.0</td>\n",
       "      <td>882.00</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>10200.0</td>\n",
       "      <td>24000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Viet Nam</th>\n",
       "      <td>104.0</td>\n",
       "      <td>28342.605769</td>\n",
       "      <td>99697.518064</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7119.00</td>\n",
       "      <td>10344.0</td>\n",
       "      <td>18027.0</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>1.0</td>\n",
       "      <td>36000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.00</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>5.0</td>\n",
       "      <td>17506.400000</td>\n",
       "      <td>24930.397125</td>\n",
       "      <td>816.0</td>\n",
       "      <td>1632.00</td>\n",
       "      <td>5452.0</td>\n",
       "      <td>19632.0</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>11.0</td>\n",
       "      <td>26338.181818</td>\n",
       "      <td>51791.586540</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>4260.00</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>180000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      count           mean            std  \\\n",
       "Country                                                                     \n",
       "Afghanistan                            24.0  148290.125000  332705.942277   \n",
       "Albania                                20.0   25611.000000   40946.849387   \n",
       "Algeria                                16.0   10362.812500    8802.055769   \n",
       "Andorra                                 2.0   88640.000000   74908.063972   \n",
       "Angola                                  2.0    5292.000000     627.910822   \n",
       "...                                     ...            ...            ...   \n",
       "Venezuela, Bolivarian Republic of...   36.0    6280.611111    6714.752459   \n",
       "Viet Nam                              104.0   28342.605769   99697.518064   \n",
       "Yemen                                   1.0   36000.000000            NaN   \n",
       "Zambia                                  5.0   17506.400000   24930.397125   \n",
       "Zimbabwe                               11.0   26338.181818   51791.586540   \n",
       "\n",
       "                                          min       25%      50%       75%  \\\n",
       "Country                                                                      \n",
       "Afghanistan                               0.0   4470.75  15163.5   23328.0   \n",
       "Albania                                   0.0  10758.00  15900.0   25944.0   \n",
       "Algeria                                 300.0   3849.00   9432.0   13284.0   \n",
       "Andorra                               35672.0  62156.00  88640.0  115124.0   \n",
       "Angola                                 4848.0   5070.00   5292.0    5514.0   \n",
       "...                                       ...       ...      ...       ...   \n",
       "Venezuela, Bolivarian Republic of...     96.0    882.00   3600.0   10200.0   \n",
       "Viet Nam                                  0.0   7119.00  10344.0   18027.0   \n",
       "Yemen                                 36000.0  36000.00  36000.0   36000.0   \n",
       "Zambia                                  816.0   1632.00   5452.0   19632.0   \n",
       "Zimbabwe                               1200.0   4260.00   7200.0   21000.0   \n",
       "\n",
       "                                            max  \n",
       "Country                                          \n",
       "Afghanistan                           1000000.0  \n",
       "Albania                                194580.0  \n",
       "Algeria                                 36000.0  \n",
       "Andorra                                141608.0  \n",
       "Angola                                   5736.0  \n",
       "...                                         ...  \n",
       "Venezuela, Bolivarian Republic of...    24000.0  \n",
       "Viet Nam                              1000000.0  \n",
       "Yemen                                   36000.0  \n",
       "Zambia                                  60000.0  \n",
       "Zimbabwe                               180000.0  \n",
       "\n",
       "[183 rows x 8 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"ConvertedComp\"].describe()\n",
    "# mean median etc of salaries convertedcomp for the all the counries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count       330.000000\n",
       "mean      14581.384848\n",
       "std       50778.971255\n",
       "min           0.000000\n",
       "25%        3888.000000\n",
       "50%        6342.000000\n",
       "75%       11676.000000\n",
       "max      810650.000000\n",
       "Name: Pakistan, dtype: float64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"ConvertedComp\"].describe().loc[\"Pakistan\"]\n",
    "# data for one country for one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"8\" halign=\"left\">Age</th>\n",
       "      <th colspan=\"8\" halign=\"left\">CompTotal</th>\n",
       "      <th colspan=\"8\" halign=\"left\">ConvertedComp</th>\n",
       "      <th colspan=\"8\" halign=\"left\">WorkWeekHrs</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>22.0</td>\n",
       "      <td>23.545455</td>\n",
       "      <td>4.055887</td>\n",
       "      <td>15.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.946590e+08</td>\n",
       "      <td>2.068229e+09</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14336.25</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>8.740000e+09</td>\n",
       "      <td>24.0</td>\n",
       "      <td>148290.125000</td>\n",
       "      <td>332705.942277</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4470.75</td>\n",
       "      <td>15163.5</td>\n",
       "      <td>23328.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>46.500000</td>\n",
       "      <td>23.088704</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>46.5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>30.0</td>\n",
       "      <td>26.766667</td>\n",
       "      <td>6.095127</td>\n",
       "      <td>16.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>30.5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1.123696e+05</td>\n",
       "      <td>1.078321e+05</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11750.00</td>\n",
       "      <td>101000.0</td>\n",
       "      <td>162500.0</td>\n",
       "      <td>3.080920e+05</td>\n",
       "      <td>20.0</td>\n",
       "      <td>25611.000000</td>\n",
       "      <td>40946.849387</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10758.00</td>\n",
       "      <td>15900.0</td>\n",
       "      <td>25944.0</td>\n",
       "      <td>194580.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>48.392857</td>\n",
       "      <td>24.442433</td>\n",
       "      <td>35.0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>51.0</td>\n",
       "      <td>28.019608</td>\n",
       "      <td>11.710662</td>\n",
       "      <td>15.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7.243125e+04</td>\n",
       "      <td>5.160359e+04</td>\n",
       "      <td>200.0</td>\n",
       "      <td>35000.00</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>1.500000e+05</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10362.812500</td>\n",
       "      <td>8802.055769</td>\n",
       "      <td>300.0</td>\n",
       "      <td>3849.00</td>\n",
       "      <td>9432.0</td>\n",
       "      <td>13284.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>36.862069</td>\n",
       "      <td>13.814392</td>\n",
       "      <td>6.0</td>\n",
       "      <td>33.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>3.0</td>\n",
       "      <td>39.000000</td>\n",
       "      <td>10.816654</td>\n",
       "      <td>30.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>43.5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.200000e+04</td>\n",
       "      <td>6.929646e+04</td>\n",
       "      <td>33000.0</td>\n",
       "      <td>57500.00</td>\n",
       "      <td>82000.0</td>\n",
       "      <td>106500.0</td>\n",
       "      <td>1.310000e+05</td>\n",
       "      <td>2.0</td>\n",
       "      <td>88640.000000</td>\n",
       "      <td>74908.063972</td>\n",
       "      <td>35672.0</td>\n",
       "      <td>62156.00</td>\n",
       "      <td>88640.0</td>\n",
       "      <td>115124.0</td>\n",
       "      <td>141608.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>42.000000</td>\n",
       "      <td>7.211103</td>\n",
       "      <td>36.0</td>\n",
       "      <td>38.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>3.0</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>25.357445</td>\n",
       "      <td>22.0</td>\n",
       "      <td>25.5</td>\n",
       "      <td>29.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.913467e+04</td>\n",
       "      <td>1.358497e+05</td>\n",
       "      <td>404.0</td>\n",
       "      <td>702.00</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>2.360000e+05</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5292.000000</td>\n",
       "      <td>627.910822</td>\n",
       "      <td>4848.0</td>\n",
       "      <td>5070.00</td>\n",
       "      <td>5292.0</td>\n",
       "      <td>5514.0</td>\n",
       "      <td>5736.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>72.333333</td>\n",
       "      <td>84.287207</td>\n",
       "      <td>9.0</td>\n",
       "      <td>24.50</td>\n",
       "      <td>40.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Venezuela, Bolivarian Republic of...</th>\n",
       "      <td>56.0</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>11.004131</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1.953347e+06</td>\n",
       "      <td>6.570264e+06</td>\n",
       "      <td>20.0</td>\n",
       "      <td>300.00</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3300.0</td>\n",
       "      <td>2.878490e+07</td>\n",
       "      <td>36.0</td>\n",
       "      <td>6280.611111</td>\n",
       "      <td>6714.752459</td>\n",
       "      <td>96.0</td>\n",
       "      <td>882.00</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>10200.0</td>\n",
       "      <td>24000.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>40.121951</td>\n",
       "      <td>20.221517</td>\n",
       "      <td>6.0</td>\n",
       "      <td>34.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Viet Nam</th>\n",
       "      <td>165.0</td>\n",
       "      <td>25.660606</td>\n",
       "      <td>8.059608</td>\n",
       "      <td>5.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>4.767837e+14</td>\n",
       "      <td>4.862258e+15</td>\n",
       "      <td>400.0</td>\n",
       "      <td>10000000.00</td>\n",
       "      <td>18750000.0</td>\n",
       "      <td>30000000.0</td>\n",
       "      <td>4.958550e+16</td>\n",
       "      <td>104.0</td>\n",
       "      <td>28342.605769</td>\n",
       "      <td>99697.518064</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7119.00</td>\n",
       "      <td>10344.0</td>\n",
       "      <td>18027.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>42.371901</td>\n",
       "      <td>19.499629</td>\n",
       "      <td>8.0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>2.0</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>5.656854</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000e+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.00</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3.000000e+03</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.00</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>10.0</td>\n",
       "      <td>28.200000</td>\n",
       "      <td>7.192589</td>\n",
       "      <td>20.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.240000e+04</td>\n",
       "      <td>3.353058e+04</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.00</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>24000.0</td>\n",
       "      <td>8.000000e+04</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17506.400000</td>\n",
       "      <td>24930.397125</td>\n",
       "      <td>816.0</td>\n",
       "      <td>1632.00</td>\n",
       "      <td>5452.0</td>\n",
       "      <td>19632.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>24.013885</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.25</td>\n",
       "      <td>40.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>19.0</td>\n",
       "      <td>25.578947</td>\n",
       "      <td>4.100349</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.737273e+03</td>\n",
       "      <td>7.843678e+03</td>\n",
       "      <td>100.0</td>\n",
       "      <td>325.00</td>\n",
       "      <td>600.0</td>\n",
       "      <td>4850.0</td>\n",
       "      <td>2.400000e+04</td>\n",
       "      <td>11.0</td>\n",
       "      <td>26338.181818</td>\n",
       "      <td>51791.586540</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>4260.00</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>39.928571</td>\n",
       "      <td>14.355188</td>\n",
       "      <td>8.0</td>\n",
       "      <td>37.00</td>\n",
       "      <td>40.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Age                                    \\\n",
       "                                      count       mean        std   min   25%   \n",
       "Country                                                                         \n",
       "Afghanistan                            22.0  23.545455   4.055887  15.0  22.0   \n",
       "Albania                                30.0  26.766667   6.095127  16.0  23.0   \n",
       "Algeria                                51.0  28.019608  11.710662  15.0  23.0   \n",
       "Andorra                                 3.0  39.000000  10.816654  30.0  33.0   \n",
       "Angola                                  3.0  40.000000  25.357445  22.0  25.5   \n",
       "...                                     ...        ...        ...   ...   ...   \n",
       "Venezuela, Bolivarian Republic of...   56.0  29.000000  11.004131  17.0  21.0   \n",
       "Viet Nam                              165.0  25.660606   8.059608   5.0  21.0   \n",
       "Yemen                                   2.0  31.000000   5.656854  27.0  29.0   \n",
       "Zambia                                 10.0  28.200000   7.192589  20.0  25.0   \n",
       "Zimbabwe                               19.0  25.578947   4.100349  19.0  23.0   \n",
       "\n",
       "                                                       CompTotal  \\\n",
       "                                       50%   75%   max     count   \n",
       "Country                                                            \n",
       "Afghanistan                           23.0  25.0  32.0      24.0   \n",
       "Albania                               25.0  30.5  38.0      20.0   \n",
       "Algeria                               26.0  29.0  99.0      16.0   \n",
       "Andorra                               36.0  43.5  51.0       2.0   \n",
       "Angola                                29.0  49.0  69.0       3.0   \n",
       "...                                    ...   ...   ...       ...   \n",
       "Venezuela, Bolivarian Republic of...  25.0  35.0  66.0      36.0   \n",
       "Viet Nam                              24.0  29.0  89.0     104.0   \n",
       "Yemen                                 31.0  33.0  35.0       1.0   \n",
       "Zambia                                28.0  29.0  46.0       5.0   \n",
       "Zimbabwe                              25.0  29.0  33.0      11.0   \n",
       "\n",
       "                                                                           \\\n",
       "                                              mean           std      min   \n",
       "Country                                                                     \n",
       "Afghanistan                           5.946590e+08  2.068229e+09      2.0   \n",
       "Albania                               1.123696e+05  1.078321e+05      1.0   \n",
       "Algeria                               7.243125e+04  5.160359e+04    200.0   \n",
       "Andorra                               8.200000e+04  6.929646e+04  33000.0   \n",
       "Angola                                7.913467e+04  1.358497e+05    404.0   \n",
       "...                                            ...           ...      ...   \n",
       "Venezuela, Bolivarian Republic of...  1.953347e+06  6.570264e+06     20.0   \n",
       "Viet Nam                              4.767837e+14  4.862258e+15    400.0   \n",
       "Yemen                                 3.000000e+03           NaN   3000.0   \n",
       "Zambia                                2.240000e+04  3.353058e+04   1000.0   \n",
       "Zimbabwe                              4.737273e+03  7.843678e+03    100.0   \n",
       "\n",
       "                                                                           \\\n",
       "                                              25%         50%         75%   \n",
       "Country                                                                     \n",
       "Afghanistan                              14336.25     65000.0    150000.0   \n",
       "Albania                                  11750.00    101000.0    162500.0   \n",
       "Algeria                                  35000.00     70000.0    120000.0   \n",
       "Andorra                                  57500.00     82000.0    106500.0   \n",
       "Angola                                     702.00      1000.0    118500.0   \n",
       "...                                           ...         ...         ...   \n",
       "Venezuela, Bolivarian Republic of...       300.00       900.0      3300.0   \n",
       "Viet Nam                              10000000.00  18750000.0  30000000.0   \n",
       "Yemen                                     3000.00      3000.0      3000.0   \n",
       "Zambia                                    2000.00      5000.0     24000.0   \n",
       "Zimbabwe                                   325.00       600.0      4850.0   \n",
       "\n",
       "                                                   ConvertedComp  \\\n",
       "                                               max         count   \n",
       "Country                                                            \n",
       "Afghanistan                           8.740000e+09          24.0   \n",
       "Albania                               3.080920e+05          20.0   \n",
       "Algeria                               1.500000e+05          16.0   \n",
       "Andorra                               1.310000e+05           2.0   \n",
       "Angola                                2.360000e+05           2.0   \n",
       "...                                            ...           ...   \n",
       "Venezuela, Bolivarian Republic of...  2.878490e+07          36.0   \n",
       "Viet Nam                              4.958550e+16         104.0   \n",
       "Yemen                                 3.000000e+03           1.0   \n",
       "Zambia                                8.000000e+04           5.0   \n",
       "Zimbabwe                              2.400000e+04          11.0   \n",
       "\n",
       "                                                                             \\\n",
       "                                               mean            std      min   \n",
       "Country                                                                       \n",
       "Afghanistan                           148290.125000  332705.942277      0.0   \n",
       "Albania                                25611.000000   40946.849387      0.0   \n",
       "Algeria                                10362.812500    8802.055769    300.0   \n",
       "Andorra                                88640.000000   74908.063972  35672.0   \n",
       "Angola                                  5292.000000     627.910822   4848.0   \n",
       "...                                             ...            ...      ...   \n",
       "Venezuela, Bolivarian Republic of...    6280.611111    6714.752459     96.0   \n",
       "Viet Nam                               28342.605769   99697.518064      0.0   \n",
       "Yemen                                  36000.000000            NaN  36000.0   \n",
       "Zambia                                 17506.400000   24930.397125    816.0   \n",
       "Zimbabwe                               26338.181818   51791.586540   1200.0   \n",
       "\n",
       "                                                                              \\\n",
       "                                           25%      50%       75%        max   \n",
       "Country                                                                        \n",
       "Afghanistan                            4470.75  15163.5   23328.0  1000000.0   \n",
       "Albania                               10758.00  15900.0   25944.0   194580.0   \n",
       "Algeria                                3849.00   9432.0   13284.0    36000.0   \n",
       "Andorra                               62156.00  88640.0  115124.0   141608.0   \n",
       "Angola                                 5070.00   5292.0    5514.0     5736.0   \n",
       "...                                        ...      ...       ...        ...   \n",
       "Venezuela, Bolivarian Republic of...    882.00   3600.0   10200.0    24000.0   \n",
       "Viet Nam                               7119.00  10344.0   18027.0  1000000.0   \n",
       "Yemen                                 36000.00  36000.0   36000.0    36000.0   \n",
       "Zambia                                 1632.00   5452.0   19632.0    60000.0   \n",
       "Zimbabwe                               4260.00   7200.0   21000.0   180000.0   \n",
       "\n",
       "                                     WorkWeekHrs                              \\\n",
       "                                           count       mean        std   min   \n",
       "Country                                                                        \n",
       "Afghanistan                                 18.0  46.500000  23.088704   4.0   \n",
       "Albania                                     28.0  48.392857  24.442433  35.0   \n",
       "Algeria                                     29.0  36.862069  13.814392   6.0   \n",
       "Andorra                                      3.0  42.000000   7.211103  36.0   \n",
       "Angola                                       3.0  72.333333  84.287207   9.0   \n",
       "...                                          ...        ...        ...   ...   \n",
       "Venezuela, Bolivarian Republic of...        41.0  40.121951  20.221517   6.0   \n",
       "Viet Nam                                   121.0  42.371901  19.499629   8.0   \n",
       "Yemen                                        1.0  40.000000        NaN  40.0   \n",
       "Zambia                                      10.0  38.000000  24.013885   8.0   \n",
       "Zimbabwe                                    14.0  39.928571  14.355188   8.0   \n",
       "\n",
       "                                                                 \n",
       "                                        25%   50%    75%    max  \n",
       "Country                                                          \n",
       "Afghanistan                           40.00  46.5   51.0  100.0  \n",
       "Albania                               40.00  40.0   50.0  168.0  \n",
       "Algeria                               33.00  40.0   40.0   70.0  \n",
       "Andorra                               38.00  40.0   45.0   50.0  \n",
       "Angola                                24.50  40.0  104.0  168.0  \n",
       "...                                     ...   ...    ...    ...  \n",
       "Venezuela, Bolivarian Republic of...  34.00  40.0   40.0  140.0  \n",
       "Viet Nam                              40.00  40.0   44.0  160.0  \n",
       "Yemen                                 40.00  40.0   40.0   40.0  \n",
       "Zambia                                16.25  40.0   48.0   80.0  \n",
       "Zimbabwe                              37.00  40.0   45.0   70.0  \n",
       "\n",
       "[183 rows x 32 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2.describe()\n",
    "# all data of all numerical columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Age            count     9.619000e+03\n",
       "               mean      3.366749e+01\n",
       "               std       1.099830e+01\n",
       "               min       1.000000e+00\n",
       "               25%       2.600000e+01\n",
       "               50%       3.100000e+01\n",
       "               75%       3.900000e+01\n",
       "               max       9.900000e+01\n",
       "CompTotal      count     8.171000e+03\n",
       "               mean     1.359823e+243\n",
       "               std                inf\n",
       "               min       0.000000e+00\n",
       "               25%       8.000000e+04\n",
       "               50%       1.100000e+05\n",
       "               75%       1.500000e+05\n",
       "               max      1.111111e+247\n",
       "ConvertedComp  count     8.152000e+03\n",
       "               mean      2.088265e+05\n",
       "               std       3.729250e+05\n",
       "               min       0.000000e+00\n",
       "               25%       8.300000e+04\n",
       "               50%       1.150000e+05\n",
       "               75%       1.596250e+05\n",
       "               max       2.000000e+06\n",
       "WorkWeekHrs    count     9.093000e+03\n",
       "               mean      4.179240e+01\n",
       "               std       8.221370e+00\n",
       "               min       1.000000e+00\n",
       "               25%       4.000000e+01\n",
       "               50%       4.000000e+01\n",
       "               75%       4.500000e+01\n",
       "               max       1.400000e+02\n",
       "Name: United States, dtype: float64"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2.describe().loc[\"United States\"]\n",
    "# all data for one country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "fltrcon1 = df[\"Country\"] == \"United States\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5964"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[fltrcon1][\"LanguageWorkedWith\"].str.contains(\"Python\").sum()\n",
    "# knowing how many people who worked with python from certain country by filter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan                              11\n",
       "Albania                                  13\n",
       "Algeria                                  40\n",
       "Andorra                                   3\n",
       "Angola                                    1\n",
       "                                       ... \n",
       "Venezuela, Bolivarian Republic of...     29\n",
       "Viet Nam                                102\n",
       "Yemen                                     1\n",
       "Zambia                                    4\n",
       "Zimbabwe                                 13\n",
       "Name: LanguageWorkedWith, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countrygrp2[\"LanguageWorkedWith\"].apply(lambda x: x.str.contains(\"Python\").sum())\n",
    "# doing same thing as above but with apply method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "percpy = countrygrp2[\"LanguageWorkedWith\"].apply(lambda x: x.str.contains(\"Python\").sum()).value_counts( normalize = True)\n",
    "# finding persentage of who are using python by country using apply nethod"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       0.103825\n",
       "1       0.081967\n",
       "2       0.065574\n",
       "3       0.060109\n",
       "10      0.043716\n",
       "          ...   \n",
       "635     0.005464\n",
       "124     0.005464\n",
       "132     0.005464\n",
       "134     0.005464\n",
       "5964    0.005464\n",
       "Name: LanguageWorkedWith, Length: 85, dtype: float64"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "percpy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3rc1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
